Show data prior to selected Month year

[Prasad1318]

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.

[mamartinezv]

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;

[Prasad1318]

Hi mamartinezv

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

regards 

Prasad

[Ruhulessin]

Hi @Prasad1318,

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

-Ruben