Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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

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