Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analysis instead of IF()? LFL(Like For Like)

Hi Guys,

I have a working If statement:

if(OpenYearWeek

<=

MaxString({$<PeriodID = {"<=$(=Max(PeriodID)-52)"}, Year = {"$(=Max(Year) -1)"}>}YearWeek)

and

ClosedYearWeek

>=

MaxString(YearWeek),sum({$<Year={$(=Max(Year))},PeriodID = {"<=$(=Max(PeriodID))"}>} #NetValue_EUR),Null())

This is a solution for Like for Like Calculation and this works properly on Store Level.

When i try this at Country Level this would not work because OpenYearWeek and ClosedYearWeek is a atribute of a single store.

Is the following true?: Should i transform this calculation somehow in Set Analysis to be dimensional independent? better said: show data on each level?

Or should i do this differently?

I'm strugeling with this issue for a long time and i'm kinda desperate for help:(

Hope someone has a genius idea!

Thanks allot!