Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

3 Replies
Not applicable
Author

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

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

Not applicable
Author

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

Not applicable
Author

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

Set Analysis Wizard for QlikView | qlikblog.at