topic Re: Chart percent in QlikView

Chart percent

QSense — Wed, 16 May 2012 07:19:31 GMT

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)

Re: Chart percent

jagannalla — Wed, 16 May 2012 08:02:48 GMT

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.

Chart percent

QSense — Wed, 16 May 2012 08:08:27 GMT

Hello,

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

Re: Chart percent

jagannalla — Wed, 16 May 2012 08:29:55 GMT

Can you please attach sample file.

Chart percent

QSense — Wed, 16 May 2012 08:31:59 GMT

My file size is big like 1.6 gb

İf you want ı can send expression and dimension

Chart percent

Anonymous — Wed, 16 May 2012 09:15:23 GMT

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

Chart percent

Wed, 16 May 2012 09:58:49 GMT

Try by checking relative checkbox in the expression tab

Chart percent

QSense — Wed, 16 May 2012 10:00:27 GMT

unfortunately

İt didnt change result

It is same

Chart percent

Wed, 16 May 2012 10:13:14 GMT

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

Re: Chart percent

QSense — Wed, 16 May 2012 10:41:14 GMT

How can I attach qw file

Chart percent

Jason_Michaelides — Wed, 16 May 2012 10:42:07 GMT

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

Re: Chart percent

QSense — Wed, 16 May 2012 10:49:09 GMT

I attached

Re: Chart percent

jagannalla — Wed, 16 May 2012 10:59:41 GMT

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

Give a value as H.

Hope it helps you.

Re: Chart percent

QSense — Wed, 16 May 2012 11:03:24 GMT

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

Re: Chart percent

QSense — Wed, 16 May 2012 13:05:40 GMT

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