Ignore selections from an entire qlikview table

[#1]

I have a case where I have two entities say 'Consumption' and 'Stock' and they are present in qlikview as separate logical tables. They are linked in the data model because there are reports where I need the combined results from the two tables.

However there are some reports for which, when I want to view the 'Consumption' data, I have to  pass some selections from Stock, but discard all other selections from Stock.

Instead of ignoring selections field by field, is there a shortcut to ignore all selections from the 'Consumption' logical table in a set analysis expression or unselect all selections from 'Consumption' table on the click of a button ?

[jeffmartins]

Hi Aushik.Makdoom,

You need to use set analysis with the constant 1.

"There is one constant that can be used to denote a record set; 1. It represents the full set of all the records in the application."

sum( {1<Region= {US} >} Sales )
returns the sales for region US disregarding the current selection.

See the set analysis in the help file.

Regards

[#3]

Hi Jeff,

Thanks a lot for your answer. Here I have indicated only two logical tables, but in my application there are many other logical tables and for viewing the consumption report, I have to ignore all selections only from 'Stock' table. However selections made on other logical tables needs to be considered.

Please let me know if you see a solution to this. Thanks in advance and sorry if I was unclear in my first post.

[jeffmartins · Accepted solution]

Hi Aushik.Makdoom,

You can ignore the selections of the 'Stock' table using a variable with all field names of 'Stock' table in the set analysis.

In my example only the selections of the fields Dim0 and Dim2 are ignored.

See the attached file.  Hope it helps you.

Regards

[SunilChauhan]

Better to use below code in expression

sum({<Dim1=,Dim2=,Dim3=,Value>}Value)

hope this helps

[#6]

http://community.qlik.com/docs/DOC-1334

check this one very helpful.

[#7]

Thanks a lot Jeff!!!! It looks to solve my issue...

[#8]

Worked very well, thank you!