Qlik Community

Qlik Sense App Development

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

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

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

May be you need this

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

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

Hi,

Try this

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

 Or as your expression was 

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

 

Hope it helps