topic Re: How to replace the current month variable with any month I select? in QlikView

How to replace the current month variable with any month I select?

Anonymous — Thu, 27 Feb 2014 23:10:11 GMT

I have a variable vCurrentMonth which on reload loads the current month.

I have a list box with that last 6 months displayed. I would like the vCurrentMonth variable to swap out the current month with the one I select.

So for instance if February is the current month and I select December. December now becomes the current month.

Thanks for your help.

Re: How to replace the current month variable with any month I select?

Thu, 27 Feb 2014 23:25:39 GMT

Hi Darrin,

You can set a trigger on Field change action, and in this set the variable value as GetFieldSelections(Month) or Only(Month) or Max(Month).

Document Properties - > Triggers -> On Fields list, select the month field and then set the action.

Tell me if you have any problem.

Regards.

Re: How to replace the current month variable with any month I select?

Thu, 27 Feb 2014 23:42:11 GMT

And if you are thinking in select more than one value for the months and you want to save all values in the variable, you can use Concat(GetFieldSelections(F1), '|').

The second parameters is a split character between values.

Regards.

Re: How to replace the current month variable with any month I select?

Anonymous — Fri, 28 Feb 2014 08:32:44 GMT

Thanks Guzman, that worked great. But one thing broke.

I have a second variable for the vPrevMonth to store the prior month which I have now set a second action on max(F1) -1

I have numbers for the months from the start of our calendar so -1 will always work and it does.

This month is 50 and my variable, when I click on Feb, does make the vPrevMonth = 49.

But it seems that my set analysis using the vPrevMonth does not work any longer. My fear is that when I select my month it now has the month as the current selection and thus drops the prior month I wish to display as well.

In a nutshell I want to take this further where when a month is selected, the previous changes and is not limited by the selection.

I hope that makes sense.

Thanks

Re: How to replace the current month variable with any month I select?

tresB — Fri, 28 Feb 2014 08:47:48 GMT

If you want previous as well as the current month data, try something like:

Sum( {<Month={$(vCurrentMonth), $(vPrevMonth)}>} Amount)

Edit:

For only previous month:

Sum( {<Month={$(vPrevMonth)}>} Amount)

If you want to disregard a field's selection then like:

Sum( {<FieldNameTobeDisregarded=,Month={$(vPrevMonth)}>} Amount)

To disregard all selections:

Sum( {1<Month={$(vPrevMonth)}>} Amount)