Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Salesorder item amount
121853 10 1
121853 20 1
121853 30 1
121853 40 1
121853 50 1
121853 60 1
121853 70 1
121853 80 1
I would like to findout how many items are having the value >=30 the amount should be shown 6
sumof rows needs to displayed in the expression
count(if(item >='30',Salesorder))
sum of row is displaying value
For reporting
Salesorder oneitem twoitem morethan3 item
121853 1 1 6
I need to display in the chart .
Advance thanks for your help.
Thanks.
I don't have Qlikview8.5 above version.Set analysis will work above 8.5 only right
I suggest a simple if test:
if(item >= 30,1,null())
When you use this calculation, the result of the column will be the count of the qualifying items within your sales order.
You can use search with Set Analysis (version 8.5 or greater) to find those values >=30 :
Good luck !
Gerardo
Thanks.
I don't have Qlikview8.5 above version.Set analysis will work above 8.5 only right
Thanks.I tried this - it didn't work