Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
I have a Sql table like below here p.todate in dd/mm/yyyy hh:mm:ss format.
from this p.todate field how to derive the Quarteryear and WeekYear fields in below format in Sql syntax only.
Please help me on this.
From products p;
Thanks in advance
if you are running in qlikview then you can extract table from sql database then do operations on extracted table using qlikview script functions.