Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Exclude Dimension with set Analysis ?

Hello,

I search solution to exclude the Values of dimension 2 based on the dimension 1 selected (1 hierarchic row below),

(Dimension 1 and 2  values are equvalent)

ex:  [nbr of box]      from Country 1 to Country 2           exclude the City offices of the coutry 1   applied to  Country 2.

Anyone have an idea ??

thks a lot

Tags (1)
5 Replies
Not applicable

Re: Exclude Dimension with set Analysis ?

Solution found!

thks

Highlighted
Not applicable

Re: Exclude Dimension with set Analysis ?

Solution found!

thks

Not applicable

Re: Exclude Dimension with set Analysis ?

Solution found!

thks

Not applicable

Re: Exclude Dimension with set Analysis ?

solution

$ <Country 2= Country 2 - Country 1> indicator

hope to help anyone

Not applicable

Re: Exclude Dimension with set Analysis ?

Solution:

sum $< Country 2= Country 2-Country 1 > Indicator

hope to help anyone