Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vadim_grab
New Contributor III

Set more that one variable in Qlik Sense

Hello, All

May be some one solved my case earlier  - I need set more than one variable by action (click button and etc) in Qlik Sense.

Briefly about my task: set two variables by button click

1 -  which  set dimension - date cycle variable (Year, Half Year, Quarter, Month, Week ,

2 - set  offset argument  Above(): 1, 2, 4,12 or 365



Many thanks for any solution or recomendations!

Vadim

1 Solution

Accepted Solutions
miskinmaz
New Contributor III

Re: Set more that one variable in Qlik Sense

Hi,

Please find the attached image for more details of How to use Sheet Navigation and Action extension to use two variables on single  one button.. The extension is available on Qlik Branch.

Try the same and hopes it solves your issue.

8 Replies
miskinmaz
New Contributor III

Re: Set more that one variable in Qlik Sense

Hi,

You can use Sheet Navigation and Action extension to set multiple variables on button click.

Regards

thi_pham
Contributor

Re: Set more that one variable in Qlik Sense

I'm not sure I got correctly your problem, but I have an idea to set more than 1 variable by one action, you can combine values of them into a common variable (like a synthetic key):

You will have one variable with combinations, such as: Year_1, Year_4 ... HaftYear_1 ... and so on (I hopes the number of combination is not too many).

And use a variable extension to support user select, such as Qlik Branch

Hope it help.

vadim_grab
New Contributor III

Re: Set more that one variable in Qlik Sense

Hi,

thank you for your attention for my task.

My needs - one click button - change two variables

Click on Month button must set  month as dimension and Above() offset argument= 12 (to compare on line chart current period and same period last year ago),

Click on Quarter - set Quarter as dimension  and offset offset argument= 4.

Example:

Qlik Sense Desktop 2018-07-16 11.09.46.png

Vadim

miskinmaz
New Contributor III

Re: Set more that one variable in Qlik Sense

Hi,

Please find the attached image for more details of How to use Sheet Navigation and Action extension to use two variables on single  one button.. The extension is available on Qlik Branch.

Try the same and hopes it solves your issue.

movendays
New Contributor

Re: Set more that one variable in Qlik Sense

Great tips mate, aswell that diagram a lot of work there!

kkkumar82
Valued Contributor III

Re: Set more that one variable in Qlik Sense

I think you can use button click for the field and if condition for setting another variable to 12

HTH

vadim_grab
New Contributor III

Re: Set more that one variable in Qlik Sense

May be. In QlikView i doing it very easy. In Qlik Sense it should be similar, but not...

if condition - not the most elegant way (my opinion)

vadim_grab
New Contributor III

Re: Set more that one variable in Qlik Sense

extension enables set two variables by the click.