topic Re: Independent Dimension from Selection with Dependent Data in QlikView

Independent Dimension from Selection with Dependent Data

Fri, 02 Nov 2012 16:36:44 GMT

I have a document that is broken up into three sections. The left is where you can make your selections, the top right is a high-level overview, and the bottom right is a trends overview. For the trends section, I have four graphs, where the x-axis is Month. I would like to make the graphs independent of the months selected on the left, but still update for other changes in the selections. I was looking through the forum for it, and I couldn't find much. What I was trying to do was to have the Dimension be Month, and then I tried changing the expression to different things I read on the internet, like {$} and similar, but it wasn't working out the way I was hoping.

Can anyone help me with this?

Re: Independent Dimension from Selection with Dependent Data

Nicole-Smith — Fri, 02 Nov 2012 16:38:45 GMT

Say for your trend chart the Dimension is Month and the Expression is Sum(Sales).

To ignore any selections made on the month field, change the expression to Sum({<Month=>}Sales)

This tells the chart to ignore any selections made on the Month field, but the chart will still be filtered by other selections.

Re: Independent Dimension from Selection with Dependent Data

Fri, 02 Nov 2012 16:41:16 GMT

I didn't realize that I needed to change it in the Expression, not the Dimension tab. Thank you!