topic Re: How to conditional dimension in Radar Chart? in QlikView

How to conditional dimension in Radar Chart?

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to conditional dimension in Radar Chart?

Gysbert_Wassenaar — Mon, 02 Jan 2017 07:25:07 GMT

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.

Re: How to conditional dimension in Radar Chart?

Anonymous — Mon, 02 Jan 2017 08:40:07 GMT

Hi Dennis,

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

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

Regards!

Re: How to conditional dimension in Radar Chart?

Mon, 02 Jan 2017 20:29:04 GMT

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)

Re: How to conditional dimension in Radar Chart?

Mon, 02 Jan 2017 20:29:35 GMT

Thanks, Manuel.

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

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

Re: How to conditional dimension in Radar Chart?

Anonymous — Tue, 03 Jan 2017 06:58:11 GMT

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

Regards!