Skip to main content
Announcements
Happy New Year! Cheers to another year of collaboration, connections and success.
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.