Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Year Month

Iam looking for a  way to populate the Year month as  column starting from 2019-01 until current month 2020-08 and  as the month changes to September . when the report is refreshed it should adapt to 2020-09

 

in the below fashion..

  2019-01 2019-02  2019-03 2019-04  2019-05 2019-06

 

thanks

Labels (1)
1 Reply
Highlighted

Hi, you can use a pivot table with YearMonth as vertical dimension