QlikView App Dev

[#1]

Is there a way to use forced exclusion for an entire table?

I thought I remembered seeing a solution in which you create a group of fields in the script and use forced exclusion on that group in the set analysis.  Does anyone know of this technique?  Can anyone think of any other solutions to force exclude an entire table?

Regards,

Max

[sunny_talwar]

Would you be able to share some sample data to explain what exactly are you trying to do?

[jonas_rezende]

It depends what you want to do ...

• Exclude table is with command drop table <name table>;
• Exclude data of table format QVD is with load incremental option delete;
• Exclude set in Set Analisys is with operator and modifier, Ex.: -={ }.

Hope it helps!

[#4]

What I would like to do is to exclude a set, rather each field in an entire table, in set analysis.

The model below is from Qlik's Expense Management demo.  Using this as an example, suppose we want to create a set analysis of the sum of all budgets, but excluding any selections made from the Expenses table.

One way to do this might be with this equation:

sum({<ExpenseKey=, Employee=, [Expense Type]=, Amount=, Date=, Billable=, Temp=  >}Budget)

But what if there are multiple tables you want to exclude with hundreds of fields?  Is it possible to force exclude the table name in the set analysis or create a group in the script that can do this?

[#5 · Accepted solution]

Hi Max,

This post is what you are looking for i think

Ignore all selections except some specific fields using Set Analysis

or

Clear Selections of all table fields in set analysis

sum({$<[$(=Concat({1<$Table={'Table1'}>}distinct $Field,']=,[')&']=')>} Amount)

[sebastiandperei]

wonderfull!!!

[#7]

For fields in and-mode, there is also the possibility of forced exclusion. If you want to force exclusion of specific field values, you will need to use “~” in front of the field name.

[#8]

Sandeep,

Thank you for this.  The top link is helpful in explaining this technique and the bottom link is the way I actually implemented, it is a bit cleaner to use in a variable.

Regards,

Max