Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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

View solution in original post

1 Reply
Gysbert_Wassenaar

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