topic Calculated dimension question in QlikView

Calculated dimension question

Thu, 02 Dec 2010 21:49:15 GMT

Hi,

I'm trying to create a calculated dimension in a chart that will do the following:

If the SYS_ID = 'WIRE_DOMESTIC_1LINK' or 'WIRE_INTERNATIONAL_ 1LINK' then '1LINK WIRES'

I tried this:

=if("SYS_ID"='WIRE_DOMESTIC_1LINK','WIRE_INTERNATIONAL_1LINK',"1LINK WIRES") with no luck.

I don't want to have to deal with this in the load script but this is only applicable for one chart. I have other objects that display these values separately. Can I do something with set analysis?

Any help would be greatly appreciated.

Thanks,

Shannon

Calculated dimension question

Thu, 02 Dec 2010 22:08:10 GMT

Hello Shannon,

if you do not want to manage it during the load process try this as your dim:

=if(SYS_ID= 'WIRE_DOMESTIC_1LINK' or SYS_ID= 'WIRE_INTERNATIONAL_ 1LINK', '1LINK WIRES')

Note that my (one) Apostroph differ from yours.

HtH

Roland

Calculated dimension question

Thu, 02 Dec 2010 22:21:33 GMT

Very helpful - thanks for your response!