topic Re: How to cycle through expression pairs in a graph? in QlikView

How to cycle through expression pairs in a graph?

robinwiman — Tue, 15 Aug 2017 07:41:22 GMT

Hi,

I have 10 expressions in my graph. Each expression has a Twin but they are current year and last year.

e.g. I have the expression "Sales" and "Sales LY", where LY= Last year.I also have "visitors" and "visitors LY" etc.

So, I want to create the possibility to cycle through the graph for a dashboard. The idea is that when a user clicks the cycle button, the graph will move from the Sales-pair to the visitors-pair and so forth.

Right now, I got TWO cycle buttons, which prompts the user to change to Sales on one button and Sales LY on the other.

Is there a way to make it cycle through pairs?

Re: How to cycle through expression pairs in a graph?

kaushiknsolanki — Tue, 15 Aug 2017 08:23:26 GMT

Hi,

You can group the Expression from the expression tab.

Regards,

Kaushik Solanki

Re: How to cycle through expression pairs in a graph?

robinwiman — Tue, 15 Aug 2017 08:28:10 GMT

Hi Kaushik,

Thank you for your answer, I am aware of the grouping feature under expression tab.

I have already grouped the expressions. What I need is the graph to cycle multiple Groups in 1 cycle.

Re: How to cycle through expression pairs in a graph?

mdmukramali — Tue, 15 Aug 2017 08:32:56 GMT

Dear ,

you can group expression :

Else you can have a workaround by created a listbox with values Sales,Visitor and Etc and based on the selection in the listbox you can set the varible value based on that variable you can write the condtional expression.

Thanks,

Mukram

Re: How to cycle through expression pairs in a graph?

robinwiman — Tue, 15 Aug 2017 08:45:22 GMT

Thank you for your response. I am aware of the grouping feature. The listbox is a nice addition but I don't think it will suffice for this dashboard.

Re: How to cycle through expression pairs in a graph?

ecolomer — Tue, 15 Aug 2017 08:49:43 GMT

See this:

Re: Cycle Shows Twice

Re: How to cycle through expression pairs in a graph?

robinwiman — Wed, 16 Aug 2017 11:13:53 GMT

It is not really a solution to my initial quesion, but I made a workaround where I created a show/hide feature from QlikTips (Show and Hide Multiple Objects - YouTube). It works for the intention that I am creating this.