Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
juancaneu
New Contributor II

In an expression, find a specific record in a table

Hi!

In a chart expression, I want to get a specific record in a table.

The table contains two fields: [date], [value].

Example:  2016-11-12, 120

                2016-11-13, 145

                2016-11,14, 208

              

Using today's date, I want to get the corresponding value in the table. (If today is 2016-11-13, I want to get the value 145.

Thank you in advance for your help.

Tags (2)
1 Solution

Accepted Solutions

Re: In an expression, find a specific record in a table

You can use an expression like this:

sum({<date={'$(=today())'}>}value)

I've also attached an example file.

2 Replies

Re: In an expression, find a specific record in a table

You can use an expression like this:

sum({<date={'$(=today())'}>}value)

I've also attached an example file.

juancaneu
New Contributor II

Re: In an expression, find a specific record in a table

Nicole:

Thank you for your precise and quick answer. I wish you a nice week!