Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!

Who Me Too'd this solution

Not applicable
‎2011-06-11 03:15 PM

try this:

tmp:

LOAD * INLINE [

    Period, Week

    1, w1

    1, w2

    1, w3

    1, w4

    2, w5

    2, w6

    2, w7

    2, w8

    2, w9

    3, w10

    4, w11

    4, w12

];

data:

load if(Period=Previous(Period),Peek(Counter)+1,1) as Counter,

    Period,

    Week

resident tmp;

drop table tmp;

Regards

View solution in original post

1 user say ditto
1,577 Views
Who Me Too'd this solution