Discussion board where members can get started with Qlik Sense.
Following is my Calendar from which I want Month Name.How to Retrive Month Name from It.
left join (April)
LOAD * INLINE [
MakeDate(Year,MONTH_NUM,1) as GDPDT
//'Q' & Ceil(NUM(MONTH_NUM)) AS GDPQuarter,
//'Q' & ceil(month(MakeDate(Year, MONTH_NUM,1))/3) as [GDPDT Quarter]
drop table April;
//Year(GDPDT) AS [GDP Year],
right(yearname(GDPDT,0,4),4) as [GDP FYear],
//Month(GDPDT) AS [GDP Month],
if(num(month(GDPDT))<=3,(num(month(GDPDT))+9),(num(month(GDPDT))-3)) AS [GDP MonthNum],
Day(GDPDT) AS [GDP Day],
'Q' & Ceil(NUM(if(num(month(GDPDT))<=3,(num(month(GDPDT))+9),(num(month(GDPDT))-3)))/3) AS [GDPDT Quarter]
DROP TABLE GDP_1;
Please post sample Application
The Script I have wrote for calendar I already attached,can you help me out from that cause I have not Application right now..
So how to Get Month Name from Above Script...?
To get month name try this out:
Date (GDPDT,'MMM') as MonthName
Isnt it simply selecting the field in your load statement? or please post a sample
Hi Thiago I got output as Apr,May,Jun....so on but My Date is of Two Years i.e. 2017 and 2018 and I want Output as Apr 2017,May 2017...Apr 2018,May 2018...so on
So how it is Possible...?
Thanks in Advanced..
Date (GDPDT,'MMM') & ' ' & Year (GDPDT) as MonthYear
Date (GDPDT,'MMM YYYY') as MonthYear
Hi Sasidhar it is working but is gives output like 01/03/2017,01/02/2017 but I want output as Apr 2017,May 2017..