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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding dimension from a bar chart

Dears

I have a bar chart showing customer and overdue amount, however I need to exclude 2 customers.

I am using this script which is showing all customers

if(Sum({<OverDueStatus={'Overdue'}>}[AmountFinal])<>0,Sum({<OverDueStatus={'Overdue'}>}[AmountFinal]))

Looking Forward to your reply.

Raaj

Labels (1)
3 Replies
sunny_talwar

May be this

if(Sum({<OverDueStatus={'Overdue'}, Customer -= {'Cust1', 'Cust2'}>}[AmountFinal])<>0,Sum({<OverDueStatus={'Overdue'}, Customer -= {'Cust1', 'Cust2'}>}[AmountFinal]))

Not applicable
Author

Sunny,

Excellent, it works.

Cheers man.

Raaj

sunny_talwar

Great