Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
wangxusq
Contributor III
Contributor III

How to show different value in popup and chart value.

Hi ,

I have a requirement, pls see the picture:

I created a chart, the bar chart measure is sum(quantity)/1000;


I need the bar chart value is sum(quantity)/1000  and the popup value shows sum(quantity).

For example, if sum(quantity)=1528123, then the bar chart value shows 1528  and the popup value shows 1528123.


It also would be OK if it can be  achived    in mashup.


Thanks.

popup.jpg

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

Try using dual function

Dual(text, number)

something like Dual(sum(quantity), sum(quantity)/1000 )


wangxusq
Contributor III
Contributor III
Author

Hi,

Thanks for your response. I tried  it according to your method, but it doesnot work.

It still keeps the same value. Any idea?