Skip to main content

New to Qlik Sense

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
crichter14
Creator
Creator

Dynamic Bookmark Scenario

I feel really dumb asking this, but I don't know how to fix it.  I've read through many posts and watched several videos for dynamic bookmarks and I'm still lost. I think I need a dummies version.

SUMMARY:  How can I make this dynamic field, dynamic in the book mark?

 

Background:  I inherited script for a field based on an inline load.  The field I am concerned with is called Measure:

PERFORMANCE_MEASURES_TEMP:
load * inline [
MeasureID,Measure
1,'BASE LINE'
2,'TOP LINE'
3,'PLAN GOAL'
4,'BEST CASE SCENARIO PLAN'
5,'CURRENT YEAR SALES'
6,'PRIOR YEAR SALES'
7,'2 YEAR AGO SALES'
];

PERFORMANCE_MEASURES_TEMP2:
LOAD *,
YEAR(TODAY()) AS CURRENT_YEAR,
YEAR(ADDYEARS(TODAY(),-1)) AS PRIOR_YEAR,
YEAR(ADDYEARS(TODAY(),-2)) AS [2 YEARS AGO]
RESIDENT PERFORMANCE_MEASURES_TEMP;
DROP TABLE PERFORMANCE_MEASURES_TEMP;

PERFORMANCE_MEASUES:
LOAD
MeasureID,
IF(MeasureID=5, Measure&' ('&CURRENT_YEAR&')',
IF(MeasureID=6, Measure&' ('&PRIOR_YEAR&')',
IF(MeasureID=7, Measure&' ('&[2 YEARS AGO]&')',Measure))) AS Measure
RESIDENT PERFORMANCE_MEASURES_TEMP2;
DROP TABLE PERFORMANCE_MEASURES_TEMP2;

Last year output:

Measure={'CURRENT YEAR SALES (2020)','PRIOR YEAR SALES (2019)','2 YEAR AGO SALES (2018)'}

This year output:

''

Expected output:

Measure={'CURRENT YEAR SALES (2021)','PRIOR YEAR SALES (2020)','2 YEAR AGO SALES (2019)'} 

 

Labels (5)
0 Replies