Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

How to conditional dimension in Radar Chart?

The variable 'Values' is used as dimension, which has five values: A, B, C, D, E.

I like the chart to use A, B, C as dimensions. I enable 'conditional dimension' in the dialogue box and input

match(values, 'A', 'B', 'C')

However, the chart still shows all the dimension values. Any ideas on the solution? Thanks.

1 Solution

Accepted Solutions
manucamon
Valued Contributor III

Re: How to conditional dimension in Radar Chart?

Hi Dennis,

It is better to filter the vars on Expressions with Set Analysis:

COUNT({<Values = {'A','B','C'}>} DISTINCT ID)

Regards!

5 Replies
MVP & Luminary
MVP & Luminary

Re: How to conditional dimension in Radar Chart?

The conditional dimension is for showing or hiding the entire dimension itself. It's not an expression to show or hide some dimension values. What you want is to use a calculated dimension. There you can use an expression like: =if(match(Values, 'A','B','C'), Values)

Is the name of the field 'values' or 'Values'? Field and variable names are case sensitive.


talk is cheap, supply exceeds demand
manucamon
Valued Contributor III

Re: How to conditional dimension in Radar Chart?

Hi Dennis,

It is better to filter the vars on Expressions with Set Analysis:

COUNT({<Values = {'A','B','C'}>} DISTINCT ID)

Regards!

Not applicable

Re: How to conditional dimension in Radar Chart?

Thanks for reply. The calculated dimension gives an additional dimension beyond A B C. I am not sure why this happens.

Manuel's solution works perfect! All I need is to replace count as sum.

Sum({<Values = {'A','B','C'}>} Score)

Not applicable

Re: How to conditional dimension in Radar Chart?

Thanks, Manuel.

This works out perfect. All I need is to replace count as sum.

Sum({<Values = {'A','B','C'}>} Score)

manucamon
Valued Contributor III

Re: How to conditional dimension in Radar Chart?

Hi Dennis, I am glad that the solution is what you need.

Regards!