topic Re: Set expression with variables in QlikView

Set expression with variables

robinwiman — Wed, 07 Mar 2018 08:13:28 GMT

Here are the variables:

I'd like to turn this statement into a set expression:

Sum ( If( [Year Week] = vYearWeekLY_YD and WeekDayNumber = vWeekDayNumberYD, Fsgexkl_Loc*Comparable_week))

But when I do it like:

Sum ( {$< [Year Week] ={'$(=$(vYearWeekLY_YD))'}, WeekDayNumber = {'$(=$(vWeekDayNumberYD))'} >} Fsgexkl_Loc*Comparable_week))

It does not work.

Where am I going wrong with this? It's always the same when dabbling with variables in set expressions - frustrating.

Thanks

bariyb23 — Wed, 07 Mar 2018 08:39:37 GMT

Try this

Sum ( {$< [Year Week] ={"$(vYearWeekLY_YD)"}, WeekDayNumber = {'$(vWeekDayNumberYD)"} >} Fsgexkl_Loc*Comparable_week))

tresB — Wed, 07 Mar 2018 08:50:19 GMT

Do you have a sample app to support and show case your issue?

robinwiman — Wed, 07 Mar 2018 09:02:26 GMT

I looked in our script and here's how the variables are created:

LET VECKANR_YD = num(Week(today()-1),00); //Week number yesterday

LET vYearWeek_YD = Year(Today()-1)&'W'& $(VECKANR_YD); //year week yesterday

LET vYearWeekLY_YD = Year(AddMonths(Today()-1,-12))&'W'& $(VECKANR_YD); //year week last year yesterday

Anonymous — Wed, 07 Mar 2018 09:14:46 GMT

Try below :

Sum ( {$ < [Year Week] ={$(=vYearWeekLY_YD)}, WeekDayNumber = {$(=vWeekDayNumberYD)} > } Fsgexkl_Loc*Comparable_week )

Anonymous — Thu, 08 Mar 2018 06:58:07 GMT

Sum ( {$ < [Year Week] ={'$(vYearWeekLY_YD)'}, WeekDayNumber = {'$(vWeekDayNumberYD)'} > } Fsgexkl_Loc*Comparable_week )