How can convert date in month and Year Format in Qlik Sense

vlakeshr — Thu, 07 Dec 2017 13:22:39 GMT

I have data (attached screen shot) as month in date format. Requirement is make a data in month and year format.

I have used cross table and transpose from column into row format in qlik sense. I am getting month but excel file containing data from Dec2016 to Dec 2017. I am able to see year 2017 in Year filter pane but no able to view year 2016.

i used calendar for month and Year as well but still year 2016 is not reflecting in QLIKSense.

I have two data file in excel format as data containing in the attached screen shot format.

Also, creating synthetic key only for "12/31/2016" and moth, let me know how to resolve it and how will get year 2016 in year filter pane.

Please advise me and provide the solution to fix this issue.

Appreciate for quick response..I want to fix this issue in the next 24 hours and it's a client requirement

Table A:

cross table ( Month,Value, 4)

Abc,

"12/31/2016",

01/23/2017",

"11/30/2017",

"12/03/2017",

From Sheetname ;

Table B:

cross table ( Month,Value, 4)

Abc,

Pqr,

Xyz,

"12/31/2016",

01/23/2017",

"11/30/2017",

"12/03/2017",

From Sheetname ;

Re: How can convert date in month and Year Format in Qlik Sense

Ralf_Heukäufer — Thu, 07 Dec 2017 15:56:10 GMT

Hello,

with your testdata in a file named Test.xlsx saved on my Desktop this works:

CrossTable:

crosstable(Datebla,Value,4)

LOAD

FROM [lib://Desktop/Test.xlsx]

(ooxml, embedded labels, table is Tabelle1);

HelpTable:

Load

date(num#(Datebla), 'DD/MM/YYYY') as Date

Resident CrossTable;

Now you have a Date field and can work with that on the dashboards like:

year(Date)

and

month(Date)

but i think the values are not right in that case.

topic How can convert date in month and Year Format in Qlik Sense in QlikView

How can convert date in month and Year Format in Qlik Sense

Re: How can convert date in month and Year Format in Qlik Sense