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: 
QFanatic
Creator
Creator

EXPRESSION, only count where min(Period)

hi, posted earlier but had no reply.

I have a dimension Period. I only want to add field called "Customers" where the period = min (Period). Sounds so simple..

after determining Min Period, I need to add the rest to the expression, ...(I think I might be able to determine this with Firstsortedvalue as well, not sure how)?

=
(if(RangeSUM(COOKIE_1,COOKIE_2) > 0,
                                                  COUNT( distinct Customers))

can anyone assist urgently?

Thanks.

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

You could try like:

COUNT( distinct {<Period={'$(=Min(Period))'}>} Customers)

 

If your period field value and output of min() expression formats match, this expression should work.

View solution in original post

2 Replies
tresesco
MVP
MVP

You could try like:

COUNT( distinct {<Period={'$(=Min(Period))'}>} Customers)

 

If your period field value and output of min() expression formats match, this expression should work.

QFanatic
Creator
Creator
Author

Thank you!