Week index number

[Anonymous]

Good day!

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.

Thanks.

[MK_QSL]

Can you provide the output also in excel?

[Anonymous]

Excel has field WeekNumber..

[MK_QSL]

So you want to derive WeekNumber for YearWeek?

[Anonymous]

Yes. By some function in expr.

[MK_QSL]

Like this?

[Anonymous]

Yes.

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.

[MK_QSL]

Either Create YearWeekID in Script using AutoNumber function

or

Use set Analysis for getting last 12/13 weeks...

either provide sample data or sample app to work

[Anonymous]

In attached model i need calculate sales for last 14 weeks by set analysis.

[jonathandienst]

In what context? In that table, weekly, or for a selected compare date in a text box?