topic Re: EXPRESSION, only count where min(Period) in QlikView

EXPRESSION, only count where min(Period)

QFanatic — Sat, 16 Nov 2024 18:58:43 GMT

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.

Re: EXPRESSION, only count where min(Period)

tresB — Mon, 09 Mar 2020 07:58:12 GMT

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.

Re: EXPRESSION, only count where min(Period)

QFanatic — Mon, 09 Mar 2020 08:45:55 GMT

Thank you!