topic Re: Count and formula in the condition in App Development

Count and formula in the condition

ZimaBlue — Fri, 16 Sep 2022 14:00:13 GMT

Hello!

I'm trying to do the following:

- I have a pivot table where the column is the months names and the rows are segments.

- as a measure, I need to use the number of users whose last order date was in the date range of each month (for each column).

I'm trying something like this

count({<last_order_date= {">=$(=date(monthstart([date])))<=$(=date(monthend([date])))"}>} distinct user_id)

in different variants (with and without (), with and without = before the formula). The formula window tells me 'OK', but the result is not displayed (displayed as null).

I cannot use the field with the date of the last order directly in the dimension with the month name, because when i'll manage this, I need to add several more measures to the same pivot table that use other date dimensions.

What am I doing wrong?

Re: Count and formula in the condition

abhijith28 — Fri, 16 Sep 2022 14:14:37 GMT

You could simply use =count( distinct user_id) right? it returns count for all months

Re: Count and formula in the condition

ZimaBlue — Mon, 19 Sep 2022 13:24:58 GMT

No, I can't, because I need conditions. last order date is not the same as date, these dimensions have a different data array. in any case, I abandoned these calculations, since I never found a way to implement this in qlik sense. Thnak you anyway