Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to give different color for certain % of the total value in a bar chart. Ex: $1000 Expenses as overall and only 3% of the value should be in the same bar. Is it possible in Qlik sense? If I use the stacked bar the subset is doubled --> one in the total value and as a separate value.
Thanks
Use a stacked bar but set your dimensions as
=0.03*[your expression]
=0.97*[your expression]
And order the dimensions such that the smaller value is shown on the bottom.
Thanks Daturpin for the solution. Is it possible not to adjust the measures values? I am trying to bring only the total expenses as a bar. But I want to show the subset in different color so that when I download the data the total remains the same.
I am trying to do it in the color option.
Use a stacked bar but set your dimensions as
=0.03*[your expression]
=0.97*[your expression]
And order the dimensions such that the smaller value is shown on the bottom.
Thanks Daturpin for the solution. Is it possible not to adjust the measures values? I am trying to bring only the total expenses as a bar. But I want to show the subset in different color so that when I download the data the total remains the same.
I am trying to do it in the color option.
I see the problem. You want the colors shown, but when you right click and download, you get the data in columns [dimension][0.97* expression][0.03* expression]?
That's a tough one. You could put in an alternate measure and only download when that 100% measure is selected... Or you could download from another chart that doesn't have the 97/3 split, or you can accept some visual error by changing the 97% to 100% and it won't look quite right but the measure will download correctly.
Or you could do the colors in a whole other way that I am not aware of? I guess it depends on what your customer wants.