Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Creator III
Creator III

Formula with set expression

Hi experts

My KPI BU-1 is not working, there seems to be a resolving problem of YYYY-MMM. For BU-1 I get this information: 

TomBond77_2-1702048447387.png

For BU-2 the same:

TomBond77_3-1702048494756.png

 

KPI: BU-1

Sum({<[Timestamp.autoCalendar.YearMonth]=
{"$(= date(Max(Timestamp.autoCalendar.YearMonth), 'YYYY-MMM'))))"}>} Sales))

KPI: BU-2

Sum({<[Timestamp.autoCalendar.YearMonth]=
{"2023-Nov"}>} Sales))

TomBond77_1-1702048285908.png

Where is the error in Formula for KPI BU-1?

Thanks, tom

 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Notice the quotes and braces are not in the correct positions in BU-1 as shown in the editor preview. 

-Rob

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Notice the quotes and braces are not in the correct positions in BU-1 as shown in the editor preview. 

-Rob