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: 
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)

1 Solution

Accepted Solutions
QSense
Creator II
Creator II
Author

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

View solution in original post

14 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Hello,

In number format don't give any number for Fixed to just leave it as empty for particular expression. For your reference see the enclosed image file.

QSense
Creator II
Creator II
Author

Hello,

As you said I leave it empty for fiixed number but it didint help me

jagannalla
Partner - Specialist III
Partner - Specialist III

Can you please attach sample file.

QSense
Creator II
Creator II
Author

My file size is big like 1.6 gb

İf you want ı can send expression and dimension

Anonymous
Not applicable

if you do not make any selection, qlikview by default treat it as full selection, hence, you can do something like if(getselectedcount (Available) >0,null(),sum( AVAILABLE)/count(DISTINCT ID_SEGMENT_CLASS))

Not applicable

Try by checking relative checkbox in the expression tab

QSense
Creator II
Creator II
Author

unfortunately

İt didnt change result

It is same

Not applicable

Try creating a sample qvw file and attach so that we can get a clear picture.

QSense
Creator II
Creator II
Author

How can I attach qw file