topic Re: Dynamic selection - issue with calculated dimension in QlikView

Dynamic selection - issue with calculated dimension

Thu, 13 Jun 2013 16:24:58 GMT

Hi,

The user is selecting a score of a customer from a list of 5 (A,B,C,D,E).

After each selection, the chart has to show only the customers that have such as score, taking into account all the others scores too.

Another words, it's like using the Exists function but in the chart.

I was trying to use the FieldIndex in a calculated dimension, but it doesn't work. Or, maybe my syntax is wrong:

=if ($(vShowRange) = 1 and FieldIndex('RangeValue',$(vRangeValue))>0, [Customer Name])

Thanks!

Re: Dynamic selection - issue with calculated dimension

Gysbert_Wassenaar — Thu, 13 Jun 2013 16:42:30 GMT

I think you're looking for indirect set analysis. See this discussion. If you post some sample data we can help you find a solution that fits your problem.

Re: Dynamic selection - issue with calculated dimension

Thu, 13 Jun 2013 19:16:27 GMT

Hi,

It sure did the job. But what I'm missing is that only the chart is impacted.

Another words, in other objects the selection is not updated.

So, after selecting a specific score, a customer might not be included in the chart (as desired),

but would not be "greyed" in a corresponding list box.

Is this expected behavior?

Thanks!