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

Concatenate lines in the display according to a date variable

Hello,

I need to be able to concatenate lines in the visualization according to a date variable.

This is what the table looks like in the data model :

NAME DATE_START DATE_END WEIGHT ...
AA01 04/15/2023 12/31/2099 5000 ...
AA01 01/12/2023 04/15/2023 5000 ...
AA01 11/24/2022 01/12/2023 5000 ...
AA01 06/21/2022 11/24/2022 3000 ...
... ... ... ... ...

When the end date is "12/31/2099", this means that the line is currently valid.

I have an insert where people can enter a date, according to this date it should display the weight to today (so DATE_FIN = '12/31/2099') in the first column, and in the second the weight to the date entered.

For example, if I enter '10/20/2022', the result would look like this:

NAME WEIGHT (currently) WEIGHT (10/20/2022)
AA01 5000

3000

If I enter '12/20/2022' :

NAME WEIGHT (currently) WEIGHT (02/20/2023)
AA01 5000 5000

 

currently, I've gone like this:
- WEIGHT (currently) : "=If(DATE_END = '12/31/2099',WEIGHT)"
- WEIGHT (date) : "=If(DATE_END >= '$(vDATEWeight)' and DATE_START <='$(vDATEWeight)',Weight)"
but I get a table this way:

NAME WEIGHT (currently) WEIGHT (10/20/2022)
AA01 5000 -
AA01 - 3000
AA01 -

-

 

Do you have any ideas on how I can do this?

Thank you for your help!

Labels (1)
0 Replies