Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To implement from Month - Year and to Month- Year filter selection in qlikview

Hi,

I have requirement where i need to populate the month and year filter in the below format. The trick is, have to do this in a manner that don't have any impact on the expressions used in qlikview. So any suggestions around back end or variable level is expected.

Untitled picture.png

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Look for alternate state.

Regards

ASHFAQ

maxgro
MVP
MVP

or you can use date island = separeted table, disconnected from other tables in your data model

here an example Set analysis - Date island

ashfaq_haseeb
Champion III
Champion III

have a look at this post too.

http://community.qlik.com/message/304371#304371

Regards

ASHFAQ

Anonymous
Not applicable
Author

Harshala

Not sure Alternate States is the way to go, could be better with variables as you asked.

Have a loot at this QlikView App: Dates, Date Ranges and Set Analysis it may give you food for thought.