Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vadim_grab
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
miskinmaz
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
miskinmaz
Creator III
Creator III

Hi,

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

Regards

thi_pham
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.

vadim_grab
Creator
Creator
Author

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
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.

Anonymous
Not applicable

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

kkkumar82
Specialist III
Specialist III

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

HTH

vadim_grab
Creator
Creator
Author

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
Creator
Creator
Author

extension enables set two variables by the click.