topic Re: Calculated dimension based on selected values in QlikView

Calculated dimension based on selected values

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I feel like this should be relatively straightforward, but my brain is not working today!

In my chart, I have a calculated dimension as I only want to show certain values from my field 'Fruit'.

=MATCH(Fruit,'Apples','Pears','Grapes')

That works fine.

But, I have also created a listbox with an expression, to show 5 out of the 20 possible fruits:

FRUIT

Oranges

Lemons

Nectarines

Kiwis

Passion fruit

In my chart, I would like Apples, Pears and Grapes to always show. But if any of the fruits in the listbox are selected, they should also show on the chart.

I was going down the 'get field selections' route, but haven't come up with a working solution yet.

Am I on the right track? Does anyone have any suggestions?

Many thanks,
Jess

Re: Calculated dimension based on selected values

sravanthialuval — Fri, 17 Mar 2017 13:45:19 GMT

Please post sample application for better understanding.

Re: Calculated dimension based on selected values

jessica_webb — Fri, 17 Mar 2017 14:06:47 GMT

Sample (hopefully) attached.

Re: Calculated dimension based on selected values

sunny_talwar — Fri, 17 Mar 2017 14:10:46 GMT

Check the attached

Re: Calculated dimension based on selected values

jessica_webb — Fri, 17 Mar 2017 14:15:05 GMT

This looks great. Is there anyway to have it without the calculation - i.e. get rid of 'Total'? I have that part in one of several conditional expressions...

Re: Calculated dimension based on selected values

sunny_talwar — Fri, 17 Mar 2017 14:17:06 GMT

Get rid of total? Isn't Total the field you are trying to plot?

Re: Calculated dimension based on selected values

CarlosAMonroy — Fri, 17 Mar 2017 14:18:23 GMT

HI Jessica,

I guess there are many ways to do it. What come to my mind right now, is maybe to create 2 expressions in the chart using conditionals for each of those.

The condition should be something like: Match(FruitField,'Fruit1','Fruit2')

Also for the 1st expression you can use set analysis to show the fruits you want and remove the calculated dimension. That will help to the performance too.

Hope that helps,

Carlos M

Re: Calculated dimension based on selected values

jessica_webb — Fri, 17 Mar 2017 14:18:36 GMT

Yes, but I don't want it to be part of the dimension, as it is already used in a conditional expression within the chart.

Re: Calculated dimension based on selected values

jessica_webb — Fri, 17 Mar 2017 14:19:35 GMT

Hi Carlos,

Thanks for your response.

I don't understand how the values would be selected in the listbox, from what you've said...

Re: Calculated dimension based on selected values

sunny_talwar — Fri, 17 Mar 2017 14:20:26 GMT

I have not used Total as a dimension, at least I don't see it... or am I missing something

Re: Calculated dimension based on selected values

jessica_webb — Fri, 17 Mar 2017 14:25:34 GMT

Sorry Sunny - no surprises, it's me not getting something!

I saw your expression and copied it straight into my calculated dimension...

Am now using it in the expression as you intended, and it works perfectly!

Problem solved, thank you so, so much!