topic Re: Switching between 2 variables in QlikView

Switching between 2 variables

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

Hello, dear Qlikers !

I have 2 variables - vWeek and vMonth and sliders for each.

The variables are used on a slider with values for sales per Week and per Month.

For example if the user moves the slider for vMonths to 100,
The visualizations will show all customers who have sales more than 100 per month.

And respectively, if the user moves the slider for vWeek to 10, it will show all customers who have sales per week more than 10.

As you can probably guess, for vWeek to show any visualizations, vMonth has to be 0, and for vMonth - vWeek has to be zero.

My question is how to make vWeek go to 0, if the user selects vMonth slider to 10.
I did a pop-up text box telling the user to select only 1 of the values. But this is bad user experience, to have pop ups with errors.
So i want to make it automatic.

Any suggestions ?
-Thanks

Re: Switching between 2 variables

marcus_malinow — Mon, 11 Sep 2017 14:20:35 GMT

In Document Properties, Triggers, you can set up a Variable Event Trigger on each of your variables.

On Change of your variables, Add Action,External, Set Variable. Set the other variables to 0

Re: Switching between 2 variables

Anil_Babu_Samineni — Mon, 11 Sep 2017 14:22:19 GMT

Could be possible using Triggers for first variable and OnChange to 0 using same variable as variable. But, How you are sliding to each from 0 -- etc..

Re: Switching between 2 variables

vishsaggi — Mon, 11 Sep 2017 14:23:08 GMT

May be create a variable trigger (From document properties Triggers tab) on vWeek to change to 0 onChange of vMonth? Is this what you want?

Re: Switching between 2 variables

Kushal_Chawda — Mon, 11 Sep 2017 14:24:22 GMT

Go to Document properties-> Triggers -> Variable event trigger -> select vMonth -> OnInput -> Add action-> External->Set variable

Variable : vWeek

Value : 0

Likewise you can set the trigger on vWeek to make the vMonth 0

Re: Switching between 2 variables

tomovangel — Mon, 11 Sep 2017 14:29:27 GMT

I have read, that Triggers aren't well accepted by , and it is bad practice to use it.

But this is Exactly what I was looking for, I will mark your answer correct, I just want to see if there is any other way without triggers

Thanks man

Re: Switching between 2 variables

vishsaggi — Mon, 11 Sep 2017 14:39:06 GMT

I believe too many triggers would be a bad practice but having fewer ones should be fine.

Re: Switching between 2 variables

tomovangel — Mon, 11 Sep 2017 14:41:08 GMT

well, in Total i got 6 triggers, because i have 6 variables 3 for week and 3 for month.

So I guess my performance will not drop down ?

right?

Re: Switching between 2 variables

vishsaggi — Mon, 11 Sep 2017 14:49:05 GMT

Should be fine.

Re: Switching between 2 variables

tomovangel — Mon, 11 Sep 2017 14:57:16 GMT

okay, Thanks my man

Re: Switching between 2 variables

marcus_malinow — Mon, 11 Sep 2017 15:26:53 GMT

Personally I tend to avoid trigger actions which change field selections as the user can find this confusing. Often I see applications where inexperienced developers have created such triggers to avoid issues which should be resolved within their data model. Setting variables via triggers is something which, if done carefully, can add a great deal of value to an application.