Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Coloful_Black
Contributor III
Contributor III

date format issue

Hello,

I have two fields of calendar month and year which I want to convert ether one of them into a valid time format " MM-YY"

eg Jan-19; Feb-20

two fields of calendar month and year:

[Calendar Year/Month]

 

[Calendar Year/Month TEXT]

 

HardToGiveAname2020_0-1598295891398.png

 

I tried to use date/date# function at load script and expression at chart....all did not return me good result.

 

HardToGiveAname2020_0-1598364701059.png

 

 

 

My challenge is I can't edit the raw data so I have to make adjustment at either load script or chart function

For unknown reasons, I cant load my qvd file...so attached the excel file instead here hoping may help tease out my problem...

Thanks 

 

 

 

0 Replies