Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
piyush_s11
Contributor

Show data for max month

Hi,

I wanted to show data for max month.

image 1.PNG

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

image 2.png

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.

8 Replies
kushalthakral
Contributor III

Re: Show data for max month

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
Contributor

Re: Show data for max month

Hi Kushalthakral,

Tried your solution. Unfortunately it is not working.

 

kushalthakral
Contributor III

Re: Show data for max month

Hi Piyush

 

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

 

Thanks

Kushal

MVP
MVP

Re: Show data for max month

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

Re: Show data for max month

Hi Tresesco,

Thanks

MVP
MVP

Re: Show data for max month

Try unchecking sort by State
piyush_s11
Contributor

Re: Show data for max month

Hi Tresesco,

Sorry did not understand your point

thanks

MVP
MVP

Re: Show data for max month

PFA