Exclude expression from set analysis

[#1]

Hi,

I have a straight table displaying several dimensions and calculating a monetary value as an expression.

I also have a bar chart using set analysis. What I would like to have is that the chart does not react to a filtering (clicking) on any value in the table's expression.It works for the dimensions like

     sum({Pipeline<Produktstatus.P={'Open','<ALL>'}, Abrechnungsbeginn.P=, [SFDC Produktgruppe.P]= >} [TCV Reportet (Produkt).P])

But adding the expression to the list of exclusions does not work.

Any ideas?

Many thanks.

[lironbaram · Accepted solution]

hi

as you can't select an expression value in qlikview

all selection are made in the diemnsion

you need to select one row in your table

and see in the current selection , in which fields selection have been made

then exclude all those fields in your set analysis