This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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'.
That works fine.
But, I have also created a listbox with an expression, to show 5 out of the 20 possible fruits:
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?
Check the attached
View solution in original post
Please post sample application for better understanding.
Sample (hopefully) attached.
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...
Get rid of total? Isn't Total the field you are trying to plot?
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,
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.
Thanks for your response.
I don't understand how the values would be selected in the listbox, from what you've said...
I have not used Total as a dimension, at least I don't see it... or am I missing something