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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

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
MVP
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
MVP
MVP

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

-Rob