Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
v_n
Contributor II
Contributor II

Measure that refers to dimension

Hello everybody,

 

I am working on a table in which I want to have a Due Date as a dimension and the Amount as a measure.

So it should look like this:

Due_Date Amount
30.11.2021 4.125.647
31.12.2021 2.215.486
31.01.2022 8.143.413

 

My formula for the amount looks like this:

=Sum({<Base_Date={"<=$(=Due_Date)"}>} [Amount])

 

Now when I select a Due_Date, it works. But when I have a list of due dates, nothing is displayed.

What am I doing wrong?

Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

Hi 

Try with If condition

Sum(If(Base_Date <= Due_Date, Amount))

Hope Base_Date and Due_Date are in same table

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

Hi 

Try with If condition

Sum(If(Base_Date <= Due_Date, Amount))

Hope Base_Date and Due_Date are in same table

Thanks & Regards,
Mayil Vahanan R
v_n
Contributor II
Contributor II
Author

Perfect! Thanks a lot!