Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Hi Dennis,

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

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

Regards!

View solution in original post

5 Replies
Gysbert_Wassenaar

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
Anonymous
Not applicable
Author

Hi Dennis,

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

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

Regards!

Not applicable
Author

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
Author

Thanks, Manuel.

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

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

Anonymous
Not applicable
Author

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

Regards!