Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vksthkkr
New Contributor III

Conditional Expression

Hi,

I am trying to make a chart of Category-Wise Expenses for the Current Month where the Budget exists.

The expression I am using is given below:

Sum ({<CATEGORY_BUDGET={'<>0'}, TRANSACTION_MONTH={Month(Today())}>} TRANSACTION_AMOUNT_OUT)

I am struggling to figure out what is wrong with this expression.

Any help would be greatly appreciated.

1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

Conditional Expression

Hi,

I believe your expression should be:

Sum ({<CATEGORY_BUDGET-={0}, TRANSACTION_MONTH={$(=month(Today()))} >}TRANSACTION_AMOUNT_OUT)

Your result might still depend on the format of the field Transaction Month. In this case, it should be in the same format of the output of month(Today())

Hope this helps,

Erich

1 Reply
erich_shiino
Honored Contributor

Conditional Expression

Hi,

I believe your expression should be:

Sum ({<CATEGORY_BUDGET-={0}, TRANSACTION_MONTH={$(=month(Today()))} >}TRANSACTION_AMOUNT_OUT)

Your result might still depend on the format of the field Transaction Month. In this case, it should be in the same format of the output of month(Today())

Hope this helps,

Erich