Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

Set expression how to add one more condition ?

Hi All

sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}>} [TOTAL_AMT])/1

DO filed :-

NOT_INVOICE

Reserve

Now i like to add condition DO=NOT_INOVICE into above expression.

I try :-

sum({$<month-={$(=Num(Month(AddMonths(Today(),DO=NOT_INVOICE,-2))))}>} [TOTAL_AMT])/1

If the above expression is correct , the value display with be same as column 2 Correct column.

Hope some one can advise me.

Paul

1 Solution

Accepted Solutions
Ivan_Bozov
Valued Contributor

Re: Set expression how to add one more condition ?

Hello! Try this:

sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}, DO={'NOT_INVOICE'}>} [TOTAL_AMT])/1

Result:

Capture.PNG

3 Replies
paulyeo11
Valued Contributor II

Re: Set expression how to add one more condition ?

my QVF

Ivan_Bozov
Valued Contributor

Re: Set expression how to add one more condition ?

Hello! Try this:

sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}, DO={'NOT_INVOICE'}>} [TOTAL_AMT])/1

Result:

Capture.PNG

paulyeo11
Valued Contributor II

Re: Set expression how to add one more condition ?

Hi Ivan

Thank it work

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Community Browser