Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
thierrytt1102
Partner - Creator II
Partner - Creator II

change the sign of a measure only for the display

Hi all,

I'd like to make a bar chart 'number of colleagues by profile'  by displaying the number next to the bar.

The bar must be negative as it is compared with another chart but the displayed number must be positive.

How can I handle this in QS?

Thanks a lot

12 Replies
thierrytt1102
Partner - Creator II
Partner - Creator II
Author

I tought Dual function could help me but no way, it doesn't work!

thx

thierrytt1102
Partner - Creator II
Partner - Creator II
Author

Thx for your response.

It's a good way to handle a comparison between 2 comparable measures.

however, in my case I have the first measure (count) and the second one is a ratio (%) -> scales are different.

complicated...

thierrytt1102
Partner - Creator II
Partner - Creator II
Author

but anyway it answers to my initial question