Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Numbers in Qlikview?

Hi all,

How can we create numbers in qlikview application. Can i create starting from 0 to Infinity.

kindly help on this.

Regads,

Chirumamilla

Labels (1)
5 Replies
Not applicable
Author

Hi ,

Use the below Script to Create a number starting from 0 to .. 100 (Max No should be static)

no.JPG

HirisH_V7
Master
Master

Hi ,

Based on records you can use ,

Rowno()

Recno()

Autonumber()

Load
RowNo() as ID
AutoGenerate 50;


Can you elaborate your requirement??



HTH,

Hirish

HirisH
Anonymous
Not applicable
Author

You can use autogenerate() at script like this:

Test:

load

rowno() as NumberField

autogenerate(100);

This will give you number till 100...

Same way you can change it as per your requirement...

Also, Infinity, dont think so exist in QV.

jonathandienst
Partner - Champion III
Partner - Champion III

How can we create numbers in qlikview application. Can i create starting from 0 to Infinity.

You are lucky indeed to have a computer with infinite memory to store all the numbers from 0 to infinity

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Infinity is not a number (NAN)