Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I've done this myself. See this example where I used an extension qsVariable and changed the charts based on buttons.
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?
Emulating cyclic dimension group in Qlik Sense Desktop
Emulating cyclic dimension group in Qlik Sense · blog.infovizion.ru
color by expression - QlikSense
Check if this helps.
You can go for Adhoc Reports kind of stuff, like this?
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
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.
I've done this myself. See this example where I used an extension qsVariable and changed the charts based on buttons.
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
yes, it will be one chart only...just you have to conditionaly able all the dimension
Can somebody give an example of this explanation? Thanks!