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: 
Anonymous
Not applicable

How to Create Dynamic Dimension in Qliksense

Hi All,

I Have four Bar Charts in my application

1- Region wise Customer

2- Ethnicity wise Customer

3- Professional wise Customer

4- Lead Source wise Customer

Now instead this four Barcharts i want to create one single chart which gives me data for all four

ex: Measure = Count of Customer , Dimension = Region/Ethnicity/Professional/Lead Source

Is this possible in QlikSense ?

can we get a drop down to select the dimension in my chart ?

Thanks in Advance

1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

I've done this myself.  See this example where I used an extension qsVariable and changed the charts based on buttons.

Makes Sense to go round in circles

View solution in original post

9 Replies
Anonymous
Not applicable
Author

Cyclic Group is the answer but it is not supported in qliksense but alternates are here for same to implement similar kind of functionality in QS, check these?

Cyclic Group in QlikSense

Emulating cyclic dimension group in Qlik Sense Desktop

Emulating cyclic dimension group in Qlik Sense · blog.infovizion.ru

Cyclic Group of Dimension in QlikSense | Qlik Community

Not applicable
Author

color by expression - QlikSense

Check if this helps.

Anonymous
Not applicable
Author

You can go for Adhoc Reports kind of stuff, like this?

Ad Hoc Reporting in Qlik Sense

Anonymous
Not applicable
Author

Hi BalRaj,

Thanks for the replay,

but we don't want to show the 4 charts , can it be possible only in one chart.

user can select his own dimension for the chart

Not applicable
Author

Hello there!

Is this what you want to do?

I have piled all the dimensions and each dimension has got a different color to clarify the data.

BarChart.PNG

ogster1974
Partner - Master II
Partner - Master II

I've done this myself.  See this example where I used an extension qsVariable and changed the charts based on buttons.

Makes Sense to go round in circles

Not applicable
Author

A technique that I use to allow my users to select their own dimension is using dollar expansion with field value / field index.

So you would need to do the following:

1) In script load an 'island dimension', something like an inline load with the 4 dimensions you want as strings

2) Bring in this field as a list box. The user will now have the option to select from one of the dimensions you made available

3) In your chart dimension use something like this $(=FieldValue('Dimension',FieldIndex('State',only(Dimension))))

4) The above dimension will not calculate when none or more than 1 dimension is selected

5) Customize expression based on this dimension

Anonymous
Not applicable
Author

yes, it will be one chart only...just you have to conditionaly able all the dimension

juliacowbe
Partner - Contributor II
Partner - Contributor II

Can somebody give an example of this explanation? Thanks!