Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
My_Rebecca
Creator
Creator

Date relevant expression

I need to calculatethe quantity with day GR_Date is greater or equal to variable Last Month End Day.

"Last Month End Day" has been reached as variable.

How to correct following expression?

count({<GR_Date>={"$(Last Month End Day)"}>}distinct(GR_Number&[GR_Line No.]))

Labels (1)
5 Replies
Chanty4u
MVP
MVP

Try this 

count({<GR_Date={">=$(=MonthEnd(AddMonths(Max(GR_Date), -1)))"}>} distinct GR_Number & GR_Line No.)

 

My_Rebecca
Creator
Creator
Author

"Last Month End Day" has been reached as variable. Your expression does not work.

My_Rebecca_0-1684829280316.png

 

Chanty4u
MVP
MVP

Can you attach full screen

Just wanted to see the results below in expression editor area 

My_Rebecca
Creator
Creator
Author

My_Rebecca_0-1684831900071.png

 

My_Rebecca
Creator
Creator
Author

Dear @Chanty4u , could you please take a look at this issue? I would not get the correct answer.