Week ([TABLE.autoCalendar.Week]) in Chart expression not working

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

Hello

I'm trying to adapt my initial code that was working on qlik sense desktop before moving to a cloud version where I don't have access to the data model nor variable setup.

The expression is (to be used into a "measure expression" 😞

sum({<[D_SALES.autoCalendar.Year]={'$(=$(vCurrentYear)-2)'},[Business unit]={'XXX'},[DSALES.autoCalendar.Week]={">=$(=vPromoStart)<=$(=vPromoEnd)"}>}QTY)

[DSALES.autoCalendar.Week] returns W01, W02..

vPromoStart returns 1,2,3....

VPromoEnd returns 3,4,5...

So, I'm trying to transfor W01, W02 into 1, 2....

week([DSALES.autoCalendar.Week]) returns 1, 2, 3...but if I insert this funtion in my expression, I don't get any result:

sum({<[D_SALES.autoCalendar.Year]={'$(=$(vCurrentYear)-2)'},[Business unit]={'XXX'},week([DSALES.autoCalendar.Week])={">=$(=vPromoStart)<=$(=vPromoEnd)"}>}QTY)

For information, I don't have access to the "genuine" date record, the developer has only left autocalendar fields in the sales table

Any advice would be appreciated

thanks

Re: Week ([TABLE.autoCalendar.Week]) in Chart expression not working

patricesalem — Sat, 06 Jul 2019 21:54:37 GMT

answering to myself

worked with

[D_SALES.autoCalendar.Week]={">=$(=vPromoStart-0)<=$(=vPromoEnd-0)"}>}NET_POSTE)

topic Week ([TABLE.autoCalendar.Week]) in Chart expression not working in QlikView

Week ([TABLE.autoCalendar.Week]) in Chart expression not working

Re: Week ([TABLE.autoCalendar.Week]) in Chart expression not working