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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counter in Script

I have Year and Month in script and want to add one more column in table which has sequential increment whenever month or year increase . Please suggest the logic to do this.

12 Replies
Not applicable
Author

Thanks Buddy it worked 🙂

Not applicable
Author

Hey Sorry Buddy for incomplete post, next time will keep in mind :-). Thanks for time

anbu1984
Master III
Master III

Temp:

LOAD Month,

     Year,

     Sales,

     Division

FROM

Data.xlsx

(ooxml, embedded labels, table is Sheet1);

Final:

NoConcatenate

Load *,AutoNumber(Year & Month) Resident Temp Order by Year, Month, Division;

Drop Table Temp;