topic Re: Re: Pivot table - Display total in QlikView

Pivot table - Display total

Fri, 04 Jul 2014 08:01:56 GMT

Hi All,

In pivot table, i tried to replace 1 with 'Yes' and 0 with 'No' and NULL with N/A but it affecting total column also.

How to avoid this. total column should display 0% instead of No. Below is the expression used in pivot table.

if(Value=1,'Yes' , if (Value=0,'No', if(SecondaryDimensionality()=1, sum(Alt(Value,0)), num(sum (Alt(Value,0))/count (MYSTERY_SHOPPER ),'0%') ) ))

Appreciate if some one help me.

Thanks,

Selva

MK_QSL — Fri, 04 Jul 2014 08:12:30 GMT

Better is this type of question posted with some sample data, which would be easier to work.

Thanks and looking forward for some sample data or sample apps.

Fri, 04 Jul 2014 09:02:28 GMT

Hi Manish,

Please find the attached sample.

Appreciate if you could help me on this.

Thanks,

Selva