Totalling by Dimension (excluiding certain data found in the Dimension)

[#1]

Hi

My objective is to display in a bar chart the total extended amount per 'CO_CD' dimension.  However I want to exclude certain  data found in thw 'CO_CD' dimension and thus not include it the total calculation)

I was able to create a straight table which includes the companys (CO_CD) I want to factor in my bar chart.

I have excluded the company (CO_CD) by building the expression on the 'CO_CD' dimension

(NOT WILDMatch(CO_CD,trim('ANZ*'),trim('BancoBilbao*')  etc ( see expression on example

From the straight table I want to be able to create another Bar chart showing the Total extended amount by CO_CD

When I add an additional expression i.e  sum( extended mount), my bar chart keeps including 'CO_CD' I want to exclude as per the expression I have built.

Your assistance would be much appreciated

Regards

Rohan

[#2]

Maybe using set analysis expression to exclude dimensions can solve this.

Something like SUM(${<CO_CD=>}, Sales);

[#3]

Thanks Jao

I go round this by computing this expression on the dimenions tab as opposed ot the expression tab

Then on the expression tab did a simple sum (extended amount)

Thanks for your suggestion though

[#4]

Also to build complex expression analysis this wizard can be helps you

Set Analysis Wizard for QlikView | qlikblog.at