Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN 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)
  • Chart

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