topic Re: Set analysis help in QlikView

Set analysis help

Anonymous — Sun, 12 Apr 2015 09:17:00 GMT

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 — Sun, 12 Apr 2015 09:20:06 GMT

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

maxgro — Sun, 12 Apr 2015 09:32:06 GMT

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

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

Anonymous — Sun, 12 Apr 2015 09:51:56 GMT

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

satishkurra — Sun, 12 Apr 2015 10:21:51 GMT

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

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

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 — Sun, 12 Apr 2015 10:34:28 GMT

Hi Sathish ,

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

Thanks

Anonymous — Sun, 12 Apr 2015 10:49:21 GMT

Answers by @Massimo Grossi and Satish Kurra are correct

Thanks