Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
andreyfcdk91
Creator
Creator

Sum of values, where value=1

Good day!

In attached model in pivot table TASK calculate count of Date, where quantity>0. And now i want to calculate sum of "1" (where quantity>0) by Spoint

But i need to do this not by deleting of DATE dimension or using in toolbox option TOTAL.

I need to do this by expression.

Best regards

5 Replies
Gysbert_Wassenaar

Try enabling the Partial Sums option for the Date dimension on the Presentation tab. Or is that what you mean with the TOTAL from the toolbox? If so perhaps you want this expression: sum(total <Spoint> aggr(count({<Quantity={'>0'}>}DISTINCT Date),Date,Spoint))


talk is cheap, supply exceeds demand
JonnyPoole
Employee
Employee

You can try enabling 'partial sum' on the presentation tab of the pivot table chart properties. That will show the totals of the '1s'. 

If that is not what you want, perhaps  you could create a sample of the end result you want in Excel and share it as i'm not 100% certain what you need.

andreyfcdk91
Creator
Creator
Author

No...My expression, which calculate "1", include IF expression.

That's why i'm looking for some way to sum this "1".

Gysbert_Wassenaar

Sum how? Over which dimension or dimensions? Post an example of what the result looks like.


talk is cheap, supply exceeds demand
Not applicable

See attached

While I admit this is not the most flexible way to do this, I think this is what you were looking for.