topic Conditional Expression in QlikView

Conditional Expression

vksthkkr — Tue, 17 Jan 2012 07:01:09 GMT

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.

Conditional Expression

erichshiino — Tue, 17 Jan 2012 19:59:58 GMT

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