topic Re: Show data for max month in QlikView

Show data for max month

piyush_s11 — Sat, 16 Nov 2024 03:44:54 GMT

Hi,

I wanted to show data for max month.

In Data as of section I wanted to selected latest month & year.

Suppose I have data for April 2019 so that should show Data as Of: Apr 2019

Also for selection

I have a filter for the same. For this filter I wanted to sort the data from latest month & year to oldest month & year.

Thanks.

kushalthakral — Fri, 26 Apr 2019 13:18:44 GMT

Hi Piyush

You can use following expression in Sort tab of that filter

Only({<[FileYear] = ,Month = ,[Data As Of] = >}FileDate)

and select descending

I hope answer your question

Thanks

Kushal

piyush_s11 — Tue, 30 Apr 2019 10:22:05 GMT

Hi Kushalthakral,

Tried your solution. Unfortunately it is not working.

kushalthakral — Tue, 30 Apr 2019 10:25:33 GMT

Hi Piyush

Please find the QVW is the same requirement you want i.e to sort months in filter

Thanks

Kushal

tresB — Tue, 30 Apr 2019 10:36:23 GMT

Try sort by expression:
=Only({1}Date#([Data As Of], 'MMMYYYY'))

piyush_s11 — Tue, 30 Apr 2019 11:09:08 GMT

Hi Tresesco,

Thanks for quick reply. Once you select any value from that filter the sorting goes on toss.

Could you please check.

Thanks

tresB — Tue, 30 Apr 2019 11:19:57 GMT

Try unchecking sort by State

piyush_s11 — Tue, 30 Apr 2019 11:22:36 GMT

Hi Tresesco,

Sorry did not understand your point

thanks

tresB — Tue, 30 Apr 2019 11:24:58 GMT

PFA