topic Chart dimension in QlikView

Chart dimension

QSense — Fri, 16 Nov 2012 10:04:37 GMT

Hello ,

İn chart , I want to add calculated dimension that get A field's value but value's description equals to 'Kritk and kritik Ariza'

My fields

Vardiyarap_rootcause Description

x Kritik

N Nothing

y Kritik-Ariza

I wanna show only x and y values in dimension

sivarajs — Fri, 16 Nov 2012 10:06:53 GMT

Try like

if(wildmatch(Description,'*Kritik*','*Kritik-Ariza*'),Vardiyarap_rootcause)

jagan — Fri, 16 Nov 2012 10:11:29 GMT

Hi,

Try this way

If(Match(Description,'Kritik','Kritik-Ariza'),Vardiyarap_rootcause)

Hope this helps you.

Regards,

Jagan.

Fri, 16 Nov 2012 10:12:20 GMT

Use below exp in calculated dimension

if(Vardiyarap_rootcause =x or Vardiyarap_rootcause =y, Description,null())

then enable the supress when value is null