Discussion Board for collaboration regarding Qlik DataMarket.
Hi Please help on this I am trying to assign autonumber for days in a month
Like this...... please help on this.
Go to Solution.
Why not Day(Date) as autoid.
Autonumber is slow.
However syntax is like this
LOAD Date,Autonumber(Day(Date),MonthName(Date)) as autoid
If You have dates like this
If You want 02 -> 2 and 05 -> 5 then use Day(Date).
If it's just for 2 months please use a INLINE LOAD as assign a auto number value.
LOAD * INLINE
This will create a auto number for dates.
Thanks for your reply that is not for 2months that is continues process.
Thank-you..... Autonumber is working for me