Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
vksthkkr
Contributor III
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
erichshiino
Partner - Master
Partner - Master

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

View solution in original post

1 Reply
erichshiino
Partner - Master
Partner - Master

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