Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

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

Re: Sum of values, where value=1

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
Employee
Employee

Re: Sum of values, where value=1

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
New Contributor III

Re: Sum of values, where value=1

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

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

Re: Sum of values, where value=1

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


talk is cheap, supply exceeds demand
Not applicable

Re: Sum of values, where value=1

See attached

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

Community Browser