topic Re: Help with filtering on calculated fields in QlikView

Help with filtering on calculated fields

Mon, 21 Sep 2015 18:53:01 GMT

I'm using the following expressions to determine what name should be shown based on date range selected. This gets me what I want to see, but when I click on a value that is being determined by the calculated dimension, it's filtering on all the fields in the calculated dimension. I only want to filter on the actual name I see. Anyone can help with this or offer a different solution.

If ([MaxDate] >= UltBrokerIncDate,UltimateBrokerName,ToBrokerName)

Re: Help with filtering on calculated fields

Anonymous — Mon, 21 Sep 2015 19:07:36 GMT

An alternative solution is to create two almost identical charts with the different dimensions, one with UltimateBrokerName, another with ToBrokerName. Show one chart or another depending on the UltBrokerIncDate condition.

No calculated dimensions, so the selection will work on click.

Re: Help with filtering on calculated fields

Mon, 21 Sep 2015 19:09:14 GMT

Can you show both charts at the same time? Row 1 may use UltimateBroker while Row 2 might use ToBroker

Re: Help with filtering on calculated fields

Anonymous — Tue, 22 Sep 2015 00:29:43 GMT

Not sure now how you want it to look like. An example would be helpful.