topic Re: Difficult expression in Qlik Sense in App Development

Difficult expression in Qlik Sense

pascos88 — Fri, 28 Sep 2018 07:04:47 GMT

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 — Fri, 28 Sep 2018 08:15:46 GMT

I think that I need Cohort Analysis.

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

MK9885 — Fri, 28 Sep 2018 12:55:55 GMT

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?