Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register 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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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