Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Count of Materials with sum greater then '0'in set analysis

Hi All,

I have requirement to show the count of Materials that have sum(Cost) value greater than '0', however the below expression which i have written is not working , please suggest how to achieve it.

if($(vLAVZC02Sum)>0,Count(Material))/Count(distinct Material)

vLAVZC02Sum = Sum({<Flag_LAV={'1'}>}Cost)

Labels (3)
2 Replies
Highlighted

May be you need this

Count({<Material = {"=$(vLAVZC02Sum) > 0"}>}Material)
Highlighted
Partner
Partner

Hi,

Try this

Count({<Cost = {"=$(vLAVZC02Sum) > 0"}>}Material)

 Or as your expression was 

Count({<Cost = {"=$(vLAVZC02Sum) > 0"}>}Material)/Count(distinct Material)

 

Hope it helps