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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kaanerisen
Creator III
Creator III

Table doesn't calculated if more than one field value selected

Hi everyone,

I need help to solve a problem that I faced.

I have a data table:

 

Validate MonthForecast MonthValue
66885,20
671.528,19
687.529,00
698.014,50
6105.014,50
6115.514,50
6122.514,50
771.500,00
786.377,41
796.788,66
7104.247,52
7114.671,04
7122.129,90

What I need is:

User can define a forecast look up month by using variable. For example if the user select 3, then the table above should look:

Validate MonthForecast MonthValue
671.528,19
687.529,00
698.014,50
786.377,41
796.788,66
7104.247,52

I achived this by using this expression, but it works only one validate month is selected.

Sum({<[Forecast Month]={"=[Forecast Month]>[Validate Month] and [Forecast Month]<=[Validate Month]+$(vMonthLookUp)"}>}Value)

I attached a sample app. Any support anyone can provide is appreciated. Thank you.

0 Replies