topic Re: Button Selection for a saison in QlikView

Button Selection for a saison

Wed, 09 Sep 2015 08:46:49 GMT

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

Re: Button Selection for a saison

Wed, 09 Sep 2015 11:32:26 GMT

Hi,

can you explain in depth,we cant get what you are trying to tell.

Re: Button Selection for a saison

qlikmsg4u — Wed, 09 Sep 2015 11:36:17 GMT

qlikscafom

Find the attached app

Re: Button Selection for a saison

krishna20 — Wed, 09 Sep 2015 11:37:54 GMT

Hi,

Can you please post sample file??It will helps us to provide a clear solution.

Re: Button Selection for a saison

jonathandienst — Wed, 09 Sep 2015 11:42:00 GMT

Create a season field in your calendar.

LOAD

Date,

Month(Date) As Month,

Pick(Month(Date), 'Win', 'Win', 'Spr', 'Spr', , 'Sum', 'Sum', 'Sum', 'Sum', 'Aut', 'Aut', 'Sum', 'Sum') As Season.

...

Now add a listbox containing Season...

Re: Button Selection for a saison

maxgro — Wed, 09 Sep 2015 11:44:24 GMT

add 4 buttons with actions, winter should be

select in field yourmonthfield

search string (Jan|Feb|Nov|Dec)

Re: Button Selection for a saison

Wed, 09 Sep 2015 11:53:22 GMT

Amazing, so much answers.

It is working now, but now I have the problemfor example I want to select Winter season for the months nov 2014, dec 2014, jan 2015, feb 2015 by one button who calls Winter.

Any idea?

Re: Button Selection for a saison

qlikmsg4u — Wed, 09 Sep 2015 11:55:39 GMT

What is your Date format?

Like 09/09/2015

or Sep 2015 ?

Re: Button Selection for a saison

avinashelite — Wed, 09 Sep 2015 11:57:33 GMT

you can do it in many ways:

1.Create a flag or field for the winter in the script , based on the button selection using action you can select the same.

2.if the Months are fixed , split the month and year and based on button hit select the months

Re: Button Selection for a saison

Wed, 09 Sep 2015 12:02:09 GMT

Dateformat is 09/09/2015

Re: Button Selection for a saison

Wed, 09 Sep 2015 12:05:54 GMT

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

Re: Button Selection for a saison

jonathandienst — Wed, 09 Sep 2015 12:15:22 GMT

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,

Re: Button Selection for a saison

datagrrl — Wed, 09 Sep 2015 12:32:48 GMT

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.