Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

set expression with date

Hi experts

Need your help. I have this formula but having an error in expression. Can you please help?

 

sum(

{<[YearMonth] >= date(MonthStart("2023-Jul"), 'YYYY-MMM')>}


Amount)

Labels (5)
1 Reply
TomBond77
Specialist
Specialist
Author

already solved:

sum(

{<[YearMonth] = {"$(='>=' & Monthstart('01.07.2023') )"}


Amount)

 

But now I need to add more logic: YearMonth is a filter dimension. I we select '2023-Jun' the formula should NOT show any value!

Can you help?