Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
HirisH_V7
Honored Contributor

Generating Break (Predefined) Numbers in Sequence.

Hi Qlikers,

 

I was trying achieve below, help me out. I want to create this To Generate Column in script with my data column No ,how it can be possible. 

As i am already having limit stored in   Let VConNumLimit=5; .

NoTo Generate
11
12
13
14
15
11
12
23
24
25
21
22
23
24
25
21
12
23
34
15
21
32
13
14
25
21
32
33

 

Pl Help me out, Attached the excel file for ref.

Thanks in advance,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Generating Break (Predefined) Numbers in Sequence.

Mod(RecNo()-1, $(vConNumLimit))+1 as [To Generate]


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

Re: Generating Break (Predefined) Numbers in Sequence.

Mod(RecNo()-1, $(vConNumLimit))+1 as [To Generate]


talk is cheap, supply exceeds demand