Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

awadah25
Contributor

Expression for + and - value

I try to make the amount of document type "Credit Memo & Payment" by and the other type by

I use this expression:

if(wildmatch([Document_Type06],'*Credit Memo*','*Payment*'),-1*[Amount06],[Amount06])

but it give me null values!

Untitled.png

1 Solution

Accepted Solutions

Re: Expression for + and - value

Hi,

Try this.

Sum(if(wildmatch([Document_Type06],'*Credit Memo*','*Payment*'),-1*[Amount06],[Amount06]))


Regards,

Kaushik Solanki

2 Replies

Re: Expression for + and - value

I think you need an aggregation for your amounts, like sum([Amount06])

- Marcus

Re: Expression for + and - value

Hi,

Try this.

Sum(if(wildmatch([Document_Type06],'*Credit Memo*','*Payment*'),-1*[Amount06],[Amount06]))


Regards,

Kaushik Solanki

Community Browser