Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator III
Creator III

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.

View solution in original post

8 Replies
Highlighted
Creator III
Creator III

Hi,

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

Regards

Highlighted
Creator III
Creator III

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.

Highlighted
Creator
Creator

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

Highlighted
Creator III
Creator III

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.

View solution in original post

Highlighted
Contributor
Contributor

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

Highlighted
Specialist III
Specialist III

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

HTH

Highlighted
Creator
Creator

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)

Highlighted
Creator
Creator

extension enables set two variables by the click.