topic qliksense set variable in QlikView

qliksense set variable

ali_hijazi — Wed, 25 Nov 2020 16:16:04 GMT

Hello

I'm new to QlikSense

I have a transaction table that has amounts in two currencies

I want the end user click a button to set a variable vCurrency

then in my expression I want to use if else statement and display either Sum(Sales_currency_1) or Sum(Sales_Currency_2)

depending on the value of the variable which is set by a button

Please advise

Re: qliksense set variable

tresB — Thu, 12 May 2016 07:05:18 GMT

if you want a button in qlik sense, you have to get one as extension. I would rather suggest to create an inline table with single field with two values, may be like:

Load * inline [

CurrencyFlag

Currency1

Currency2

];

And then define your variable like vCurrency=CurrencyFlag. Now when the users selects a value from CurrencyFlag, it gets assigned to the variable. Then your if expression should work fine.

Re: qliksense set variable

ali_hijazi — Thu, 12 May 2016 07:18:37 GMT

Sounds good

but how to get these extension and how to get them work?

Please advise

Re: qliksense set variable

tresB — Thu, 12 May 2016 07:22:04 GMT

A similar discussion is here: How we can create Buttons with actions in Qliksense? Please check the Qlik Branch links there.