Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression as Variable (in variable overview)

Hi,

Im trying to store the below expression into a variable, but the value of the variable only shows the total value for all dates.

How do I make it show the correct value for each date? Expected result in the red marked column.

In the other column I've put SUM($(vONIB))

SUM({<[FLOW TYPE]= {'O/N IB'}>} IF([FLOW EFFECTIVE DATE]<=DATE and [FLOW MATURITY DATE]>= DATE,AMOUNT))

Capture.JPG

Any ideas?

Regards,

Olle

1 Solution

Accepted Solutions

Re: Expression as Variable (in variable overview)

Remove the = character from the expression in your variable. And use $(vONIB) instead of sum($(vONIB)) as chart expression.


talk is cheap, supply exceeds demand
1 Reply

Re: Expression as Variable (in variable overview)

Remove the = character from the expression in your variable. And use $(vONIB) instead of sum($(vONIB)) as chart expression.


talk is cheap, supply exceeds demand
Community Browser