topic Re: a switch with absolute or average monthly values. in QlikView

a switch with absolute or average monthly values.

MilenaDrozdova10 — Sun, 15 Mar 2020 00:04:54 GMT

Hello, I need to add a switch that allows comparing the values of indicators by absolute or average monthly values.

I suppose I need to add a slider, but I don’t know how to write an expression.

Thank you

Re: a switch with absolute or average monthly values.

lblumenfeld — Tue, 17 Mar 2020 01:53:28 GMT

I need a little more information to know exactly wheat you're trying to do, but I think you're looking to do something like this.

Put a set of buttons on the sheet that let's the user toggle between "absolute" or "average" values. The use the selection to control a calculation. If so then you'd do the following...

Create a variable in your load script. I'll call mine "ValueType". Set this to a default value. I'll use "Absolute".

Set ValueType = "Absolute";

Then add something to your sheet to let the user toggle the variable between "Absolute" and "Average". I'd recommend the QS-Variable extension that Qlik just added to the Dashboard Bundle. It's pretty self-explanatory, but reply if you need help with this.

Then, in your formulas you'd do something like this...

If('$(ValueType)' = 'Absolute', do the calculation for absolute, do the calculation for average)

Let me know if this helps. If not then please post a little more detail.

Re: a switch with absolute or average monthly values.

MilenaDrozdova10 — Mon, 16 Mar 2020 09:31:13 GMT

Hello, I have several indicators on my analytical model. I need to add a switch that allows you to switch the indicator data by absolute or average monthly values. I assume that the data should change in all indicators on the sheet when switching.

"Then add something to your sheet to let the user toggle the variable between "Absolute" and "Average". I'd recommend the QS-Variable extension that Qlik just added to the Dashboard Bundle. It's pretty self-explanatory, but reply if you need help with this."

Yes, I need help with that, because I don`t know how to do that.

Thank you.

Re: a switch with absolute or average monthly values.

lblumenfeld — Tue, 17 Mar 2020 02:29:30 GMT

I've attached an app that does what I explained in the prior post. Take a look at it and let me know if this is what you were looking for.

Re: a switch with absolute or average monthly values.

Brett_Bleess — Wed, 08 Apr 2020 18:24:56 GMT

Are you using QlikView or Qlik Sense? The file left for you is for Qlik Sense, and if that is what you are using, then I need to move your post to that product area, but if you are using QlikView, confirm back. The best place I can give you to try to find some more helpful posts would be the Design Blog area, there are over 700 posts there, mostly how-to related that may give you some further ideas on how to approach things.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett