Discussion Board for collaboration related to Creating Analytics for QlikView.
Colleagues, tell me please, has QV some function to get index number of values in some field (not in load script)
Model and necessary WeekNumber in attached file.
Can you provide the output also in excel?
Excel has field WeekNumber..
So you want to derive WeekNumber for YearWeek?
Yes. By some function in expr.
but RowNo get row number of field which is set in dimensions.
in need to calculate sum for last 13 weeks, that's why i need calculate number index of all YearWeeks.
Either Create YearWeekID in Script using AutoNumber function
Use set Analysis for getting last 12/13 weeks...
either provide sample data or sample app to work
In attached model i need calculate sales for last 14 weeks by set analysis.
In what context? In that table, weekly, or for a selected compare date in a text box?