Exclude expression from set analysis

Mon, 14 Jul 2014 07:01:17 GMT

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.

Re: Exclude expression from set analysis

lironbaram — Mon, 14 Jul 2014 07:26:10 GMT

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

topic Re: Exclude expression from set analysis in QlikView

Exclude expression from set analysis

Re: Exclude expression from set analysis