topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Thu, 30 Apr 2015 14:56:03 GMT

HI all,

I have to show one kpi in which i need to show Current Week VS Last 4 Week with next for week forecast

what would be the logic.

like i made following variables

vTodayWeek = week(today())

vLast4Week = WeekStart(vTodayWeek)-4

please help me in proper expression and with next for week logic

thanks

Re: Logic Help

jpenuliar — Thu, 30 Apr 2015 15:08:02 GMT

have a look at below using InWeek():

Re: Last Weeks Activity

Re: Logic Help

sunny_talwar — Thu, 30 Apr 2015 15:08:57 GMT

If I were you I would flag Current week (may be as 1) and last 4 weeks (may be as 2) and use them in my set analysis, instead of using a variable to do this.

Flagging should be easy and can be done in the Master Calendar script itself.

HTH

Best,

Sunny

Re: Logic Help

jpenuliar — Thu, 30 Apr 2015 15:09:11 GMT

You can flag your dates instead of Variables