Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to define measures separately in Bar Chart?

Hey all,

I have a bar chart with two measures like this

Barchart.png

I want to fit the size of the second measure which is displayed in %, so that the bars are displayed larger. When i put in a min/max value it nearly displays what i want to, but it cuts the maxvalues of my first measure.

Barchart2.png

I tried with a combo chart, but in this i can only define the y-axis seperatly when i use lines, not bars.

Any Ideas?

BR

Leon

6 Replies
ogster1974
Partner - Master II
Partner - Master II

in your combo chart measure select the 2nd measure and set it to the secondary axis that will bring your values into proportion.

Regards

Andy

Not applicable
Author

Thx for your reply but like i described in my post, i dont want to show a line, i want to show bars. And i cannot set a secondary axis when i choose bars.

Regards

ogster1974
Partner - Master II
Partner - Master II

I see. In my example I used a Line for % and bar for volume so didn't have your issue.

Looks like Sense doesn't allow the same measure type in different axis for the combo chart.

If you use a standard bar chart with 2 bar measure and for the percentage value you (* by 100) and format the number as a percentage your bar values look like they would align better.

Regards

Andy

Michael_Tarallo
Employee
Employee

Thanks Andy.

Hi Patrik plu‌ - just a simple FYI

Regards,

Mike

Regards,
Mike Tarallo
Qlik
ogster1974
Partner - Master II
Partner - Master II

Glad I could help.

I think the challenge for Qlik Sense would be using the standard colour pallet the first bar value is blue the second red etc...  In a combo chart you would have 2 bar values being generated with the first colour blue. Which would not look great.  It would need to be clever enough to start from the 2nd colour for the secondary axis which it does for the line value.

Regards

Andy

amien
Specialist
Specialist

*100 works .. and i set the pattern to : #.###0,0

but is it still possible to add a %? when i change it to #.###0,0% is does * 100 again