Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Darumaka
Contributor
Contributor
‎2020-05-25 08:49 AM

YYYYMM to date variable

I have a numeric variable that contains year and month in the format YYYYMM and I have a few questions.

How do I create a date variable from this variable (day can be 1)?
What is the best way to create  another variable with the format YYYY-MM? (need this for presentation)

In the end I want to have a way to make a column that calculates the difference compared to same month previous year, will the date variable help me achieve this?

Grateful for help and also if someone could redirect me to some documentation on this topic.

5,170 Views
0 Likes
10 Replies
Darumaka
Contributor
Contributor
‎2020-05-27 04:45 AM
Author

In response to rubenmarin

Ok, I get that to work but it means that it can't be used together with the variable Year_Month in the dimension. It is perfectly fine, I have now created a new table for the differences using the year and monthname dimension (not the combined year and month). So I am content.

292 Views
0 Likes