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: 
etiennesan
Contributor III
Contributor III

Set analysis with inferior for measure

Hello everyone,

I am trying to build a bar chart where my measure is called ForecastDate, but then I want to show the sum of the data for with Date is inferior to the ForecastDate of the current bar.

I tried with this formula:

 Sum({<Date={"<$(=ForecastDate)"}>} QuantityDestructed) 

But it is not working.

I found a few solutions of how to do it when using variables, but none about explaining how to do it when using the measure.

Thank you very much for your help!

2 Replies
MayilVahanan

Hi @etiennesan 

Try like below, Create a variable like "vMinForecast"

vMinForecast =Min(ForecastDate)
Sum({<Date={"<=$(=Date(vMinForecast,'YourDateFormat'))"}>} QuantityDestructed)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
etiennesan
Contributor III
Contributor III
Author

Hello,

Thank your for your reply!

I guess I was not clear enough, I want this to be dynamic to be used in my graph. For example see below:

etiennesan_0-1621496386661.png

This is what I currently have. I want to add to each bar the sum that I am trying to write. 

Am I using the right approach?