topic Re: value showing based on some other column value in QlikView

value showing based on some other column value

Thu, 25 Jul 2013 11:38:57 GMT

Hi All,

I have the data like below in Pivot table.

Column A Column B Column c

Name XXX India

YYY Singapore

ZZZ China

Accout Savings Hongkong

Current Malaisai

Demat US

I want to put Column B as blank like - or spcae when Column A have Account and Column C should be as usual.

Thanks,

Ravi Teja.

Thu, 25 Jul 2013 11:44:24 GMT

Just create a ColumnB as calculated dimension like below.

If(ColumnA='Account','-',ColumnB)

Hope helps U.

Regards,

Kabilan K.

Thu, 25 Jul 2013 11:45:57 GMT

in calculated dimension write this code

if(columnA='Account','-',ColumnB)

********************************************

or in script write this code

LOAD *,

if([Column A]='Accout','-',[Column B]) as [Column B _new];

LOAD * INLINE [

Column A, Column B, Column c

Name, XXX, India

Name, YYY, Singapore

Name, ZZZ, China

Accout, Savings, Hongkong

Accout, Current, Malaisai

Accout, Demat, US

];

see attachement