Qlik Community

Qlik Support Discussions

Discussion Board for collaboration related to Qlik Support.

Highlighted
chaitanyajami
New Contributor III

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 II

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 

Community Browser