Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression for create MonthSeqNum work fine :-
AutoNumber(num(year(TempDate)) & num(month(TempDate), '00')) as MonthSeqNum,
Below expression also work fine but return 9598 :-
sum({$< year=, month=, MonthSeqNum = {"$(=only(MonthSeqNum-0))"} >} Amount/$(Columndim89)/1000)
May i know how to make it display 2239 ?
Paul
my QV file
Do you have just one auto number field or are you using auto number more than once?
If you use auto number on more than one field, each instance should have its own Auto ID parameter.
AutoNumber(num(year(TempDate)) & num(month(TempDate), '00'), 'MonthSeq') as MonthSeqNum,
Also the sequence created by auto number does not persist between reloads.
See this blog for more details. QlikView Addict: QlikView Functions: autonumber()