Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krithikarees
New Contributor

Return 0 when there is clearing date (Invoices report)

Hello All,

I have a table where I am trying to get null values when there is a clearing date and not bucket it. As net due date is the day an invoice was opened and if a clearing date exists it should return null values. Any suggestions?

3 Replies
OmarBenSalem
Esteemed Contributor

Re: Return 0 when there is clearing date (Invoices report)

basically if there a clearing date, the net due should be null()?

maybe change ur net due measure to:

if(len(trim(clearing))>0,null(),sum(NetDue))

krithikarees
New Contributor

Re: Return 0 when there is clearing date (Invoices report)

No - If I have a clearing date . I do not want any amounts to reflect in the buckets I have  and If there is no clearing date - I want it to show in the bucket.

OmarBenSalem
Esteemed Contributor

Re: Return 0 when there is clearing date (Invoices report)

then u'll have to change the measures of all of ur buckets the same way as previously shown

Community Browser