topic Re: Set Analysis using expression-based variables in QlikView

Set Analysis using expression-based variables

Anonymous — Wed, 15 Oct 2014 14:30:13 GMT

All,

I'm trying to create a graph that will parse out up to 4 picks made by a user from a list box and haven't had much luck. As you can see in the attached file (Test.qvw), when all items are selected within the listbox, my text boxes are picking up the individual, selected values. However, when I try and assign those values to a variable and use them in an expression, I seem to be having a problem as the expression doesn't evaluate properly (The 1st blue box above the graph when 'A' is selected shouldn't evaluate to 0.)

What am I doing wrong? Can this not be done in QV currently? Is there a better way that 4 separate values from the same list box can be comparatively graphed? I'm relatively new to QlikView and even newer still to Set Analysis functionality. Thanks much!

Re: Set Analysis using expression-based variables

c_gilbert — Wed, 15 Oct 2014 14:42:59 GMT

Do you need to use set analysis? if you simply used 'Letter' as a 2nd dimension, and just have the one expression, the chart will show whatever is selected.

Re: Set Analysis using expression-based variables

Anonymous — Wed, 15 Oct 2014 14:48:46 GMT

Your solution is simple and easy to implement. It's apparent that I was over-thinking this. Thanks so much!