Hi, I have 10 bookmarks and each bookmarks have some common and different selections between each other.
I have sum(sales) and for suppose for one bookmark name ='A', I have sum(sales)=100 and
for another bookmark name = 'B' , I have sum(sales)=200 and for another bookmark name ='c', I have sum(sales)=300.
now I want to see all the 3 bookmark values sum i.e., 100+200+300 = 600. if we combine the 3 bookmarks selections and create a new bookmark, for some selections in bookmark 'A', some values are not highlighted in bookmark 'B' then, if we combine the bookmarks, for 'A' the value may be 70 and for 'B' the value maybe 150 and for 'c' the value maybe 100 and together it will be 320. but if we sum the values when the bookmarks are selected individually, it will be 600. So, the bookmark selection should be individual and the individual selection values 100+200+300=600 should be displayed.
can any one tell me on how to achieve this or is this even possible in Qlik sense ?