topic Re: Is it possible? in QlikView

Is it possible?

Fri, 04 Jul 2014 13:10:00 GMT

Hi All,

Is it possible in the pivot table to change the values from 1 to 'Yes' and 0 to 'No' in Columns MS1,MS2,MS3,MS4. and total column should get affected.

Please help.

Thanks,

Selva

Re: Is it possible?

Anonymous — Sat, 05 Jul 2014 08:58:01 GMT

Have you tried using the dual() function in the load script? Maybe something like :

if ( MS1 = 1 , dual('Yes', 1), dual('No', 0) ) as [MS1Dual] ,

If you really want to you could use this expression in the pivot table, but personally I would always do it in the load script.

Best Regards, Bill

Re: Is it possible?

Sat, 05 Jul 2014 11:18:42 GMT

Hi Selva,

To avoid any change in total :

if(MS1=1,Dual('Yes',1),if(MS1=0,Dual('No',0),MS1))

Same goes for all the four expressions

To change your total :

if(MS1=1,'Yes',if(MS1=0,'No',MS1))

Re: Is it possible?

Sun, 06 Jul 2014 02:14:59 GMT

Hi,

My script is as below

Crosstable(Questions, Value,4)

SQL Select MYSTERY_SHOPPER, DEALER, COUNTRY, WAVE, Q1, Q2, Q3, Q4, Q5,Q6,Q7A,Q7B,Q8,Q9,Q10,Q11,Q12,Q13 from tablex

In Pivot table , below are the dimensions

Questionsow

MYSTERY_SHOPPER

In Pivot table , below is the expression.

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

How can i use the Dual function to display 1 as 'Yes' and o acs 'No'.

Appreciate if you could help me on this.

Re: Is it possible?

Anonymous — Sun, 06 Jul 2014 08:54:00 GMT

if ( SecondaryDimensionality()=1 ,

if ( sum(Alt(Value,0)) = 1 ,

Dual('Yes',1) ,

if ( sum(Alt(Value,0)) = 0 ,

Dual('No',0) ,

sum(Alt(Value,0)

)

num(sum (Alt(Value,0))/count (MYSTERY_SHOPPER ),'0%')

)

Re: Is it possible?

Sun, 06 Jul 2014 09:18:41 GMT

Thanks a lot bill.markham