Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
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
manucamon
Specialist III
Specialist III

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
manucamon
Specialist III
Specialist III

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)

manucamon
Specialist III
Specialist III

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

Regards!