Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gauravgs
Contributor

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
Honored Contributor II

Re: How to Create Dynamic Dimension in Qliksense

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

8 Replies
balrajahlawat
Esteemed Contributor

Re: How to Create Dynamic Dimension in Qliksense

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

Re: How to Create Dynamic Dimension in Qliksense

color by expression - QlikSense

Check if this helps.

balrajahlawat
Esteemed Contributor

Re: How to Create Dynamic Dimension in Qliksense

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

Ad Hoc Reporting in Qlik Sense

gauravgs
Contributor

Re: How to Create Dynamic Dimension in Qliksense

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

Re: How to Create Dynamic Dimension in Qliksense

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
Honored Contributor II

Re: How to Create Dynamic Dimension in Qliksense

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

Re: How to Create Dynamic Dimension in Qliksense

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
Esteemed Contributor

Re: How to Create Dynamic Dimension in Qliksense

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