on 09-08-2014 7:26 AM
Hi Manna,
I assume that you have 2 characteristics and one key figure and for each characteristic you have a combination of two values (such as char-1 having values a or b, char-2 having values c or d and in your screenshot you have data for a,c and b,d)
You need to have restricted key figures for each combination if you desire a condition on any combination of two characteristics. (I suppose you want to show only values greater than 0 for a,c combination of data). Then you can add a condition for the RKF (with a,c combination) to show values greater than 0.
Regards
Yasemin...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manna,
If you are going to build a query for all of the materials, then create an RKF (RKF1), add your key figure and restrict material type with WIP and for the other RKF (RKF2) add your key figure and restrict material type with Finished. Now you have two RKFs. Create a condition on RKF1 greater than 0 and select material as the characteristic. In the query remove material type from the query.
Hope it helps
Regards
Yasemin...
Hi Manna,
I am not sure if you have applied the procedure in the suggested way. This is a procedure that works pretty for sure. You can remove material type (I assume you have only two types), and give the suitable names to the RKFs. (Such as WIP KYF and Finished KYF). Please share the screenshots of your query, how you defined the RKFs and the condition. Then maybe we can advise what to do...
Regards
Yasemin...
Hi Yasemin,
please use the link to download the various screenshot
Hi Manna,
I just realized that you hide RKFs. Please remove ZMES_QKLA from columns (you can remove it from query, you already have that information in RKFs), hide formula1 and make RKFs visible. (Since RKF is visible the condition you created is not applied when you run the query)
Regards
Yasemin...
If you have only two chars to display you might take the static route. Instead of placing the chars in the columns create two restricted key figures based on the chars and then use boolean if else to achieve your results. Something like RKF1 = 0 * RKF2 + RKF1
Regards,
Dhrubo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
create a prequery, retrieving only the dates you desire.
In prequery, restrict your char to first value, create condition on the keyfigure (NE 0) and in the rows set your days as result.
in the main query, use replacement path variable to retain your result list of the prequery.
run the report with your initial setup. and you have achieved it
check out doc ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manna,
Can you try with the below setting.
Righclick on KF>GOTO Calculations tab>In local calculation: Calculate result as:Hide>Calculate single value as:Moving average.Pls check this setting it might help you.
Best,
SAtya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manna,
i hope this is your output:-
Date KF1 KF2 (please correct here ,if you dont have 2 KFs)
so your requirement will be,, if KF1 is null, don't display KF2 value.
we can do condition on KF1 not equal to zero as told above , but the overall result row still considers all the values in aggregation.
Or in KF2, you can have the condition as if KF1> 0, then KF2 value, else 0. and then you can suppress the zero values from the report.
or the column values you are mentioning ,both are char values, and not KF values? if so, you can filter out # values in the filter section.
Regards,
Sakthi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manna,
i got it..
so this is what your output:
chocolate biscuits
01.01.2014 100 100
02.02.2014 0 50
on a particular day, if the chocolate has the value, then only display that particular row?
If so, you can try with RKF restricted with chocolate, and apply the condition on this RKF.
plz try once and let us know. also i guess this works when we know the char value beforehand, if it gets change, we need to do something else i guess.
I may not correct somewhere. experts can advise further if this doesn't work.
Regards,
Sakthi
Create a Condition on your first "KF Not Equal to Zero".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.