Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgs
Creator
Creator

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
Master II
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
balrajahlawat
Champion
Champion

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

color by expression - QlikSense

Check if this helps.

balrajahlawat
Champion
Champion

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

Ad Hoc Reporting in Qlik Sense

gauravgs
Creator
Creator
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

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
Master II
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

Not applicable

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

balrajahlawat
Champion
Champion

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

juliacowbe
Partner
Partner

Can somebody give an example of this explanation? Thanks!