topic Rotate multiple expressions in a chart in QlikView

Rotate multiple expressions in a chart

Tue, 19 Jan 2016 09:23:47 GMT

Hi,

I have Six expressions my chart. First two expressions show development of two different percentages over time. The other four are exactly the same expressions but with two different weight factors. Is it possible to group these expressions so that I have one rotation button which displays two expressions at a time? Or do I have to create button object and use variable and conditional display?

1) first two expressions, non weighted

2) third and fourth expression, weighted with factor 1

3) fifth and sixth expression, weighted with factor 2

Re: Rotate multiple expressions in a chart

Anonymous — Tue, 19 Jan 2016 15:49:02 GMT

If you did not need 2 expressions changed at once, then you could use a cyclic group for your expression. So, to meet your requirement I would pursue the button with the variable and conditional display as the path of least effort.

Re: Rotate multiple expressions in a chart

MarcoWedel — Wed, 20 Jan 2016 22:37:33 GMT

Hi,

instead of switching the expression using a button and variables, can't you just switch your factors in a variable using a button and use this variable in only one set of two expressions?

regards

Marco

Re: Rotate multiple expressions in a chart

MarcoWedel — Wed, 20 Jan 2016 22:40:23 GMT

if changing just one variable/factor in your expressions isn't enough, you could also switch complete expressions using the Pick() function:

=Pick(vSwitch,
      <Your Expression 1>,
      <Your Expression 2>,
      <Your Expression 3>
     )

hope this helps

regards

Marco

Re: Rotate multiple expressions in a chart

MarcoWedel — Tue, 31 May 2016 19:44:22 GMT

glad you liked it.

Please close this thread by selecting a correct answer if your issue is solved.

thanks

regards

Marco