Hi,
I have a requirement wherein I have to diregard a particular division and display the sum of sales of the other Divisions.
In the sample application attached i am trying to acheive the same by disregarding the Division 'A'
These are the following approaches used by me:
Approach 1:
=sum({<Flag={1},
Division-={'A'}>}Sales)
This approach not only excludes division A but it also excludes the NULL divisions,but all i want is to exclude the Division A and not the NULL divisions
Approach2:
=sum({<Flag={1},
Division={'*'}-{'A'}>}Sales)
This also gives me the result as in approach 1
Approach3:
=sum({<Flag={1}>
-<Flag={1},Division={'A'}>}Sales)
This approach gives me the desired results.But I want to know if there is any built in function within qlikview that could be used to accomplish this requirement in a better way
