Use variable to display a changing target based on dimension

lessassy — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have several bar charts which display some values (let's say sales) based on weeknumber (at the format YYYY-MM) for and month (at the format monthname-YYYY)

I used a cycle group to display week value and month value.

But the issue is every year the target evolved.

And each year there is a month target and in some case a week target.

I don't know how to do: "Ok qlikview if we are in this year then the target for this month is"

I tried if(year="maxstring(Year)",Target())

And even if it worked it wouldn't work for the month. Because i'm using a master calendar

MasterCalendar:

Load

TempDate as Created,

Year(TempDate) As Year,

week(TempDate) As Week,

WeekYear(TempDate) & '-' & Num(Week(weekstart(TempDate)),'00') as WeekYear,

Month(TempDate) As Month,

Day(TempDate) As Day,

YeartoDate(TempDate)*-1 as CurYTDFlag,

YeartoDate(TempDate,-1)*-1 as LastYTDFlag,

inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,

date(monthstart(TempDate), 'MMM-YYYY') as MonthYear,

ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,

WeekDay(TempDate) as WeekDay

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

And i want to say to qlik view if the weeks or month belongs to a specifi year then apply the target to this specific month or week.

Do you know what would be the exact sentence for the variable overview pleaseee !!

Thank you in advance

topic Use variable to display a changing target based on dimension in QlikView

Use variable to display a changing target based on dimension