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: 
QSense
Creator II
Creator II

Chart percent

Hi ,

I have chart . When I do not select any attribute Chart percent values are like 700.000 %,800.00% but after I have selected some attributes values become 70%,80%

Without any selection I want to see less than %100 values

my expression is =sum( AVAILABLE)/count(DISTINCT ID_SEGMENT_CLASS)

14 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Click "Use advanced editor" on the top right of the reply box.

QSense
Creator II
Creator II
Author

I attached

jagannalla
Partner - Specialist III
Partner - Specialist III

In Number Tab of chart properties -> Thousand Symbol ->  H.

Give a value as H.

Hope it helps you.

QSense
Creator II
Creator II
Author

It only gives abbrevation for thousand I dont see more than %100 values without any selection

QSense
Creator II
Creator II
Author

=avg(aggr(sum(AVAILABLE)/count( distinct ID_SEGMENT_CLASS),ID_FLIGHT_NUMBER,DS_DATE_ORIGIN_YMD))