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

How to bring a fixed value from a date based data source to a line based on a different date

I guess my formar question was not clear so I will elaborate:

I have a data source that is loaded to the BI:

Workingdaystable.jpg

I want the value that matched to todays date to appear in the following column, regardless the date appear in the line, meaning that I would like the value of today (2) to appear even if the date on the line is yesterday (and tomorrow I would like the value 3 to apear in all lines)

reportneeded.jpg

I tried the following:  avg({1<[Date Diff] = {0}>} [MonthlyAccomulatingWorkingDays]) , but as you can see it shows me the correct value only in the total line.

 

Thanks in advance for your assistance

Amir

 

 

Labels (1)
  • SaaS

2 Replies
Or
MVP
MVP

avg({1<[Date Diff] = {0}>} total [MonthlyAccomulatingWorkingDays])

Ishragil
Contributor III
Contributor III
Author

Great
Thanks a lot