Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

How to show aggregated measure value with Dimension value.

Hi,

We are using Qlik Sense Enterprise Jun - 18. And we need to create the following chart as it is. Is there any way of achieving this ?

Capture.PNG

We've tried a couple of things, but it didn't work. We created a dimension based on field "Persona" and our measure is "SMS". Following were couple of the expressions that we've tried:

=Persona & SUM(Total Persona SMS)

=Persona & SUM(Total SMS)

We also thought to use two charts instead of one to achieve this, but when we click on a bar for filtering, before actually selecting the confirmation tick that appears on left top corner of chart, all other charts get filtered and the two charts that we used to create a visualization like above get out of sync.

Is there any way to achieve this ? or at least something close to this ?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: How to show aggregated measure value with Dimension value.

You could actually create a Widget based on the Widget example that comes with Qlik Sense named "barchart". You can extend that with adding a color dimension and editing the HTML and CSS.

It wouldn't be very hard to get exactly what you want this way if you have some skills with HTML, CSS and basic Angular.

4 Replies
MVP
MVP

Re: How to show aggregated measure value with Dimension value.

You could actually create a Widget based on the Widget example that comes with Qlik Sense named "barchart". You can extend that with adding a color dimension and editing the HTML and CSS.

It wouldn't be very hard to get exactly what you want this way if you have some skills with HTML, CSS and basic Angular.

rangam_s
Contributor II

Re: How to show aggregated measure value with Dimension value.

Qlik Branch

You can use Horizontal Bar chart to generate similar Graph (but not exactly same). You can use above extension for creating custom bar chart.

Partner
Partner

Re: How to show aggregated measure value with Dimension value.

Thanks Petter,

I guess this is the only option left. I was wondering if someone has already built and extension for this. I guess not!

Wth our installation, we didn't get the Widget examples, so I guess we'll have to start with scratch.

Thanks for your help.

Partner
Partner

Re: How to show aggregated measure value with Dimension value.

Hi Rangam,

Thanks for your response. I don't think this extension fulfills our requirement. As petter suggested, we would have to go with custom widgets.