Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting distinct values (A) higher than (B)

Hi all,

I am trying to count distinct INSTANT_NUMBERS since last order (ANSWER_TYPE = 'Y'). As the dates when there was no answer are 0, I am taking max SEGMENT_NUMBER and counting distinct Instants where the SEGMENT_NUMBER is higher. The dimension is CUSTOMER_NUMBER. I manage to get the correct answer only when I select one customer, bet I need the information for all database.

That's what I'm trying:

=count(DISTINCT{$<SEGMENT_NUMBER={">$(=max({<ANSWER_TYPE={'Y'}>}SEGMENT_NUMBERR))"}>} INSTANT_NUMBER)

pic.JPG

I would appreciate any help!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you!