Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Highlighted

Re: Help in expression

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


talk is cheap, supply exceeds demand
1 Reply
Highlighted

Re: Help in expression

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


talk is cheap, supply exceeds demand
Community Browser