Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Labels (1)
5 Replies
Not applicable
Author

Solution found!

thks

Not applicable
Author

Solution found!

thks

Not applicable
Author

Solution found!

thks

Not applicable
Author

solution

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

hope to help anyone

Not applicable
Author

Solution:

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

hope to help anyone