Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
vlakeshr
Contributor

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

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 ;

.


1 Reply
Highlighted
Partner
Partner

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

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.