topic rank changes when selections are made. in QlikView

rank changes when selections are made.

fashid — Mon, 04 May 2015 10:28:51 GMT

Hi,

I have a chart which has ranks .

The rank is calculated in the chart with the means of variables

The problem is that when i select a particular branch the rank changes to 1.

How do i prevent this behavior.

I tried using {1} but was unsuccessful.

I cannot change the variables as they are being used in other charts also.

I am attaching a copy of my app for reference.

Regards,

Nadeem

Re: rank changes when selections are made.

sunny_talwar — Mon, 04 May 2015 10:49:19 GMT

Changing the variable is the only place where you can do this. Else make another set of variables just for your rank function or alternatively replace your variable with the whole expression in your chart expression because those variable expressions will need {1} in order for them to work.

Another possible workaround could be to move this chart to another state and then any selection in the inherited state will drive any changes to this chart as it will be in an alternate state.

HTH

Best,

Sunny