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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please tell me the result for query

Hi,

Could anyone tell me what is the result for below query?

[Calendar]:

LOAD *

,date(yearstart("Date",0,4),'YYYY') as "Financial Year"

;

LOAD date(fieldvalue('Date',recno())) as "Date"

AUTOGENERATE fieldvaluecount('Date');

Thanks.

0 Replies