Qlik Community

Qlik Sense App Development

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

Highlighted
chaitanyajami
Contributor

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)
Gabriel
Valued Contributor III

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