Discussion Board for collaboration on QlikView Layout & Visualizations.
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)
Go to Solution.
=avg(aggr(sum(AVAILABLE)/count( distinct ID_SEGMENT_CLASS),ID_FLIGHT_NUMBER,DS_DATE_ORIGIN_YMD))
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.
As you said I leave it empty for fiixed number but it didint help me
Can you please attach sample file.
My file size is big like 1.6 gb
İf you want ı can send expression and dimension
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))
Try by checking relative checkbox in the expression tab
İt didnt change result
It is same
Try creating a sample qvw file and attach so that we can get a clear picture.
How can I attach qw file