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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button Selection for a saison

Hi,

i want to create a button who make a selection for a saison. For example I qlick on a winter button and he select months jan, feb, nov, dec. I want to have the some with summer etc...

Can someboady help me?

Kind regards

Mario

12 Replies
Not applicable
Author

I created a field in the script what tells me the current months with year

DATE(MonthStart(InvoiceDate), 'MM - YYYY')

But how can I tell the button when I press year 2015 and button "winter" he should take month nov. 2014, dec. 2014 and jan.2015, feb. 2015

jonathandienst
Partner - Champion III
Partner - Champion III

Use the script fragment i already gave you:

Pick(Month(InvoiceDate), 'Winter', 'Winter', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Winter', 'Winter') As Season,

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
datagrrl
Creator III
Creator III

I am not sure what you are calling Seasons. Would November be both Fall and Winter? If so You might need fields in your master Calendar called Fall, Winter, Spring, Summer and write something in your script to complete that field.