Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

Week index number

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.

32 Replies

Re: Week index number

Can you provide the output also in excel?

andreyfcdk91
New Contributor III

Re: Week index number

Excel has field WeekNumber..

Re: Week index number

So you want to derive WeekNumber for YearWeek?

andreyfcdk91
New Contributor III

Re: Week index number

Yes. By some function in expr.

Re: Week index number

Like this?

andreyfcdk91
New Contributor III

Re: Week index number

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.

Re: Week index number

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

andreyfcdk91
New Contributor III

Re: Week index number

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

MVP
MVP

Re: Week index number

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser