topic Re: Edit dimension in straight table in QlikView

Edit dimension in straight table

narender123 — Thu, 07 Jan 2016 13:49:05 GMT

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

Anonymous — Thu, 07 Jan 2016 13:51:36 GMT

try this, some misplacement are their:

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

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

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

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

its_anandrjs — Thu, 07 Jan 2016 14:03:20 GMT

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 — Thu, 07 Jan 2016 15:18:31 GMT

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:

Else This way,

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

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

,Value))

As your Caluculated Dimension,

Hope this helps,

Hirish