Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Siraj
Contributor
Contributor

Need to convert the Year data into quarter data

Hi 

I have data like below 

Region,Year,Quantity

AP,2019,400

Europe,2020,400

I need to convert the data into below format

Region,Year,Quarter,Quantity

AP,2019,Q1,100

AP,2019,Q2,100

AP,2019,Q3,100

AP,2019,Q4,100

Europe 2020,Q1,100

Europe 2020,Q2,100

Europe 2020,Q3,100

Kindly help me to achieve this

 

Thanks in advance

 

Regards

Sirajahamed S

 

2 Replies
Lisa_P
Employee
Employee

You need to have dates or quarterly data to derive this information.

Siraj
Contributor
Contributor
Author

Hi Lisa,

 

Thanks for the information, can you explain bit detail, it is very helpful for me..

 

 

Regards

Sirajahamed S