topic Re: exclude selection in QlikView

exclude selection

warrentk80 — Wed, 20 Jan 2016 09:46:20 GMT

Hello everyone, I created a dashboard where the opening of the page displays the data of the last month available (thus opening the document I select the first division) and it may object selection to select the previous months.

the same dashboard I made a chart where I have to represent the sum of sales for all months of the year, but the chart being the selection of the active month shows me only a month.

as a rule the selection of the month in the chart?

Thanks for collaboration

Andrea

Re: exclude selection

sunny_talwar — Wed, 20 Jan 2016 09:47:26 GMT

To exclude selection in the month field you can try this:

{<Month>}

Re: exclude selection

warrentk80 — Wed, 20 Jan 2016 09:51:59 GMT

Thanks for the quick reply, but I did not understand 😞

The expression I use is = Sum ([Sales])

the dimension is month.

thanks

Re: exclude selection

sunny_talwar — Wed, 20 Jan 2016 09:53:35 GMT

If you want to exclude selection in month field than change your expression to this:

Sum({<month>} Sales)

Re: exclude selection

manojkulkarni — Wed, 20 Jan 2016 09:53:54 GMT

try

sum({<MonthFieldName=>}Sales)