Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

User selected dimension

Hi,

Is it possible to let the user decide which dimension to show in a visualization?

I have a combo chart with two axes with lines representing two different KPIs. What I want to do is to let the user choose which KPI they want to compare by clicking on a filter view or dropdown or similar. If not, is there some other pattern to visualize this? There will be 2^2 different combinaions of kpis to compare so it's not feasible to create different combo charts for every one of them.

Thanks

Viktor

1 Solution

Accepted Solutions
mountaindude
Partner Ambassador
Partner Ambassador

Yes it can probably be done.

I've done the same thing but with a line chart with a single line in it.

The user can select one of several metrics from a list to the left, and that metrics is then shown in the line chart.

We also set up the dimension (x-axis) of the chart to be driven dynamically, specifically it is possible to choose whether months or individual dates should be shown horizontally.

Some tricks are needed to achieve the above though, don't think you can do it with QS out of the box.

We used two different extensions from Qlik Branch.

1. CVL Dimenlist is used to drive the dynamic dimension

2. Qlik Sense Option List is used to drive the dynamic changing of metrics

You need to couple the above extensions with some inline tables where you define the metric names and their associated formulas, as well as some IF statements in the expressions for the chart measures.

I know... a sample app would be useful. Too busy right now, hopefully the above will get you started in the right direction.

/Göran

Please mark the post as a solution if it provided you with a solution to the topic at hand. Thanks!

View solution in original post

11 Replies
ariel_klien
Specialist
Specialist

Hi,

you can do that.

please see the attachment.

see in Tab Reports.

BR

Ariel

Not applicable
Author

You could enable or disable the expressions representing thouse KPI's. To do this you could add buttons for each one of them and enable the expressions on conditions of thouse buttons being clicked.

If you want to change what each axis represents, you could use cyclic groups to cycle arrond different dimensions:

Not applicable
Author

Ariel is right. If you need more info, it´s called "Adhoc" reporting or dimensions.

Regards,

Angel

Not applicable
Author

Thanks for the reply,

I should have been more clear. I'm using Qlik Sense. Not Qlik View. Is it still possible?

/Viktor

jagan
Luminary Alumni
Luminary Alumni

Hi,

In QlikSense if you have Edit permission then user can drag the required dimension and measures into the charts.

Regards,

Jagan.

Not applicable
Author

Hi,

Thanks for the reply.

We want to avoid using the edit functionalitty for this use case though, since we will deploy this app to be used by several users, and letting everyone editing the app on the fly might create some confusion, dont you think?

jagan
Luminary Alumni
Luminary Alumni

Hi,

LOAD one table with Measures like Sales, Gross margin, Gross margin%, and use this expression in chart

=Pick(Match(Only(Measure), 'Sales', 'Gross margin', 'Gross margin%'), Sum(Sales),, Sum(Sales) - Sum(CostPrice), Sum(Sales)/Sum(CostPrice))

Hope this helps you.

Regards,

Jagan.

mountaindude
Partner Ambassador
Partner Ambassador

Yes it can probably be done.

I've done the same thing but with a line chart with a single line in it.

The user can select one of several metrics from a list to the left, and that metrics is then shown in the line chart.

We also set up the dimension (x-axis) of the chart to be driven dynamically, specifically it is possible to choose whether months or individual dates should be shown horizontally.

Some tricks are needed to achieve the above though, don't think you can do it with QS out of the box.

We used two different extensions from Qlik Branch.

1. CVL Dimenlist is used to drive the dynamic dimension

2. Qlik Sense Option List is used to drive the dynamic changing of metrics

You need to couple the above extensions with some inline tables where you define the metric names and their associated formulas, as well as some IF statements in the expressions for the chart measures.

I know... a sample app would be useful. Too busy right now, hopefully the above will get you started in the right direction.

/Göran

Please mark the post as a solution if it provided you with a solution to the topic at hand. Thanks!
Not applicable
Author

Thanks, I'll have a look at these extensions (and yes, a sample app would be great)!