topic A general query? in QlikView

A general query?

Thu, 16 Jun 2011 15:48:51 GMT

Hello Experts,

I have a Dimension called Asset as shown in the image here. I am doing a sum(value) in a pivot chart for this dimension. I want to drop off or avoid showing the 3 fields highlighted as seen below from this Pivot chart... Is that possible by Set Analysis or any othe way as i cannot delete them from the source file...

Thanks in advance

A general query?

sicilianif — Thu, 16 Jun 2011 16:01:58 GMT

For set analysis you would add {<[Assets-={'Fees','VAT on fees','Whole Book'}>} to your sum(value).

A general query?

Thu, 16 Jun 2011 16:04:30 GMT

I know that, but what if i want to avoid them or ignore them... from calculating???

Thanks for your fast reply,

Mady

A general query?

sicilianif — Thu, 16 Jun 2011 16:07:56 GMT

The minus sign in front of the equals in the set analysis will exclude those assets from being included in the calculation, and therefore would drop those dimensions from the pivot table.

A general query?

Thu, 16 Jun 2011 16:19:30 GMT

=num(sum({<[Assets- ]= {'Whole Book'}, year = {'2011'}>}MTDTable), DataFormat) I have somethig like seen here... so here I used the - sign as suggested by you and it doesnt seem to work???...

Can you explain more please... Thanks Again

A general query?

sicilianif — Thu, 16 Jun 2011 16:22:25 GMT

The minus should be outside the brackets and just before the equals:

=num(sum({<[Assets]-= {'Whole Book'}, year = {'2011'}>}MTDTable), DataFormat)

A general query?

Thu, 16 Jun 2011 16:34:41 GMT

Thank you for all the help and your time 🙂

A general query?

Thu, 16 Jun 2011 16:56:16 GMT

Hello further to the issue mentioned here, what if I want to remove these fields at the load script level, so that they are not used anywhere in the application?? They are coming from the SQL Table, Dashboard, Assets: I have the below load script.

Dashboard:
Load

Assets,
Profits,
Budget,
Other tables

From dbo.xyz table.

Thanks Again

A general query?

sicilianif — Thu, 16 Jun 2011 18:07:25 GMT

You can just add a where clause to your SQL statment:

WHERE Assets <> 'Fees' and Assets <> 'VAT on fees' and Assets <> 'Whole Book'