Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

3 Replies

Re: Excluding dimension from a bar chart

May be this

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

Not applicable

Re: Excluding dimension from a bar chart

Sunny,

Excellent, it works.

Cheers man.

Raaj

Re: Excluding dimension from a bar chart

Great

Community Browser