Pre Calculated Like For Like boolean

Thu, 26 Sep 2013 09:11:59 GMT

Hi Guys,

I'm hoping someone could help me. I work for a retail organisation with allot of stores spread globaly.

When i would like to build a high level (Global or country for example) dashboard that shows the store performance disregarding new openings or closings of stores i would need a like for like calculation.

Like for Like defenition: show only data(turnover for example) of stores that where open lastyear same period and are currently still open.

I would like to build a boolean for this so users can select if they want all the figures to be like for like or not.

Every Store has an openyearweekcode and a closedyearweek code. When a store is open, the closedyearweekcode is 2099W52.

If its closed, the closedyearweekcode containts the year/week when the store is closed.

I would like to build in script a following if statement:

If (openyearweekcode <= currentyearweek – 52

and

closedyearweekcode >=currentyearweek

'Like For Like'

'All Data')

I've converted openyearweekcode,closedyearweekcode and yearweekcode to the same date format.

I've also created a autonumber field on yearweekcode to cound back 52 weeks.

Hopefully you could help me with the last bit!

Thanks allot!

Re: Pre Calculated Like For Like boolean

Thu, 26 Sep 2013 16:11:23 GMT

I've come allot further.

I'm only struggeling with yearweek count back to 52weeks.

I am trying resident load

on Max(PeriodID) -52.

This does't seem to work. Any Idea's?

Thanks!

topic Re: Pre Calculated Like For Like boolean in QlikView

Pre Calculated Like For Like boolean

Re: Pre Calculated Like For Like boolean