Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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; .
No | To Generate |
1 | 1 |
1 | 2 |
1 | 3 |
1 | 4 |
1 | 5 |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
2 | 5 |
2 | 1 |
2 | 2 |
2 | 3 |
2 | 4 |
2 | 5 |
2 | 1 |
1 | 2 |
2 | 3 |
3 | 4 |
1 | 5 |
2 | 1 |
3 | 2 |
1 | 3 |
1 | 4 |
2 | 5 |
2 | 1 |
3 | 2 |
3 | 3 |
Pl Help me out, Attached the excel file for ref.
Thanks in advance,
Hirish
Mod(RecNo()-1, $(vConNumLimit))+1 as [To Generate]
Mod(RecNo()-1, $(vConNumLimit))+1 as [To Generate]