Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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