topic Re: WHERE condition in chart calculated dimension in QlikView

WHERE condition in chart calculated dimension

matthewp — Wed, 09 Mar 2016 10:56:06 GMT

i have a chart with a calculated dimension

it contains 4 possible values A, B, C, or D

however in my bar chart i only want it to contain B and C

i tried

=MATCH(CATEGORY, 'B','C',)

but this just numbered them

Anonymous — Wed, 09 Mar 2016 11:00:03 GMT

try like this?

if(Category='B' or Category='C', Category)

And Tick Suppress with Null Values

Kushal_Chawda — Wed, 09 Mar 2016 11:02:05 GMT

You are missing if condition. try like this

if(MATCH(CATEGORY, 'B','C'),CATEGORY)

hic — Wed, 09 Mar 2016 11:03:09 GMT

I would use Set Analysis in the measure, e.g.

Sum( {$<Category={B,C}>} Amount )

instead of

Sum( Amount )

HIC