Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

narender123
Valued Contributor

Edit dimension in straight table

Hi All,

I am  editing a dimension under "straight table> dimension> edit" but not able to do it completely.

Like:

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods' ))))

its working .

But its not working when use like this

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods' ))),cpcdesc)

This type will work in script level but why not under straight table dimension?

Thanks,

Narender

3 Replies
balrajahlawat
Esteemed Contributor

Re: Edit dimension in straight table

try this, some misplacement are their:

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods',cpcdesc))))

Re: Edit dimension in straight table

Try this one

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods',

if(Not Match(cpcdesc,'C4201','C4301','C427','C422'),cpcdesc)))))

Regards,

Anand

HirisH_V7
Honored Contributor

Re: Edit dimension in straight table

Hi ,


IF you want to load field with n Number  of changes,You can use replace,

T:

LOAD * INLINE [

    Type, Value

    Simple, 2

    Expect, 4

    Common, 8

   ];

T:

REPLACE ONLY  LOAD * INLINE [

    Type

    1

   2

   3

];

output:

Replace new.PNG

Else This way,

=If(match (Value,'8'),'Common'

,If(match (Value,'4'),'Other'

,Value))

Replace new 2.PNG

As your Caluculated Dimension,

Hope this helps,

Hirish

HirisH
“Aspire to Inspire before we Expire!”