topic Show data prior to selected Month year in App Development

Show data prior to selected Month year

Prasad1318 — Mon, 15 Aug 2022 11:07:24 GMT

Hi all,

I got a requirement where I need to show data in a table chart, prior to selected Monthyear .

Here all the fields in the table are dimensions . And there is a date field named “Date Created”. Since I don’t have measures in the table I cannot use set analysis,How can I achieve this.

Please help me on this. It will be great help.

Thank you

Regards,

Prasad.

Re: Show data prior to selected Month year

mamartinezv — Thu, 08 Sep 2022 07:16:27 GMT

Hello;

If the data in a field for each line is unique, you could use the only function which is an aggregation function and allows you to use set analysis.
If you want, you could share the Qlik.

All the best;

Re: Show data prior to selected Month year

Prasad1318 — Thu, 15 Sep 2022 10:02:32 GMT

Hi mamartinezv

thanks for the reply , can you write a sample expression for the above

regards

Prasad

Re: Show data prior to selected Month year

Ruhulessin — Thu, 15 Sep 2022 11:39:08 GMT

Hi @Prasad1318,

Do you have a yearmonth field present in your calendar?
Try this: Aggr(Only({<YearMonth = {"<$(=Max(YearMonth))"}>} [Date Created]), [Date Created])

-Ruben