Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

abeyphilip
Contributor 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

Re: Help in expression

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


talk is cheap, supply exceeds demand
1 Reply

Re: Help in expression

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


talk is cheap, supply exceeds demand
Community Browser