Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qliekview
Contributor 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)

Tags (1)
1 Solution

Accepted Solutions
qliekview
Contributor II

Re: Chart percent

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

14 Replies
jagannalla
Valued Contributor III

Re: Chart percent

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.

qliekview
Contributor II

Chart percent

Hello,

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

jagannalla
Valued Contributor III

Re: Chart percent

Can you please attach sample file.

qliekview
Contributor II

Chart percent

My file size is big like 1.6 gb

İf you want ı can send expression and dimension

soulessfreedom
New Contributor

Chart percent

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

Chart percent

Try by checking relative checkbox in the expression tab

qliekview
Contributor II

Chart percent

unfortunately

İt didnt change result

It is same

Not applicable

Chart percent

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

qliekview
Contributor II

Re: Chart percent

How can I attach qw file

Community Browser