D
D
Denis Lvov2020-10-28 13:20:11
API
Denis Lvov, 2020-10-28 13:20:11

How to correctly write the formula for qlik sense in set analysis?

Sorry for the wrong tag

There is a formula like this in measure
count(distinct {<[Date]={">=$(=date(max([Date])-90))<=$(=date(max([Date] )))"}>} [id])

there is a pivot table in by month.
The bottom line is that the result for the last 90 days is displayed in the cell.
those. if October, then we look at the last maximum date - 90 days, we get two dates. We consider everything that fell into this interval. and so on for each month.

but now it doesn't feel right. just takes the interval from the maximum date and counts purely within the month

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question