Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
matthewp
Contributor III

WHERE condition in chart calculated dimension

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

1 Solution

Accepted Solutions

Re: WHERE condition in chart calculated dimension

You are missing if condition. try like this

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

3 Replies
balrajahlawat
Esteemed Contributor

Re: WHERE condition in chart calculated dimension

try like this?

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

And Tick Suppress with Null Values

Re: WHERE condition in chart calculated dimension

You are missing if condition. try like this

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

Employee
Employee

Re: WHERE condition in chart calculated dimension

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

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

instead of

  Sum( Amount )

See A Primer on Set Analysis

HIC

Community Browser