Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
abeyphilip
Creator II
Creator II

Help in expression

Hi,

My data looks like this. The requirement is to count the customers that are deactivated (having status as "D"). In the example below - my count of deactivated customers  should return 1 - i.e. CustC. Because only for that customer the status is D for all dates. Can this be done as an expression?

QV_Data.png

Thanks,

Abey

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try: count({<Cust= e({<Status-={'D'}>} Cust) >} distinct Cust)


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Try: count({<Cust= e({<Status-={'D'}>} Cust) >} distinct Cust)


talk is cheap, supply exceeds demand

View solution in original post