Difficult expression in Qlik Sense

[pascos88]

Hi,

I have to calculate a not easy expression in qlik sense I try to explain

have the following table

Day                       Count Access               Count access 1 day before         Count access 2 days before

28/09/2018                    320                                   162                                             80

the problem is that in the column 'Count access 1 day before' I have to consider only the set of access that have an access in 28/09/2019.

so 162 are the users within 320

Any Idea how I can solve it ?

Thanks for any suggestion

[pascos88]

I think that I need Cohort Analysis.

Any suggestion how I can create the formula and with object I have to use?

[MK9885]

Sorry can you try to explain more on what you expecting?

What should be the result for what and are those Count columns already there in your model?