Set analysis help

[Anonymous]

Hi

Please explain me what does the following expression mean

sum(<Region=,Country=>Sales)

does it gives the all sales data related to region and Country ? Correct me if i am wrong .

Thanks

[Anonymous]

sorry !! the correct expression is sum({<Region=,Country=>}Sales)

[maxgro]

sum( {<Region=,Country=>} Sales )

sales for the current selection, but with the selection in Region and Country removed

[Anonymous]

ok !! it means we wont get the data for Region and country  ???

[satishkurra · Accepted solution]

Hi

Yes you are correct. You can understand yourself by performing the below

Below is the sample data, load it in Qlikview, Reload

Country	Region	Sales
A	X	100
B	Y	200

Create a straight table and Dimension as Country and expressions as

1. Sum(Sales)

2. Sum({<Region=,Country=>}Sales)

Click Finish

Now get the Country, Region object to the presentation layer and perform selection

Now observe how your expressions are behaving.

Thanks

Satish

[Anonymous]

Hi Sathish ,

Thanks for your reply !! The values remain unchanged even after selection . I got it

Thanks

[Anonymous]

Answers by @Massimo Grossi  and Satish Kurra are  correct

Thanks