Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
robinwiman
Creator
Creator

How to cycle through expression pairs in a graph?

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?

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

You can group the Expression from the expression tab.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
robinwiman
Creator
Creator
Author

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.

mdmukramali
Specialist III
Specialist III

Dear ,

you can group expression :

3.PNG

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

robinwiman
Creator
Creator
Author

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.

ecolomer
Master II
Master II

robinwiman
Creator
Creator
Author

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.