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

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
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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: 
kprotrka
Contributor III
Contributor III
‎2021-07-26 09:10 AM

Grouping per month

I have a date column(Budget_applied_date) which means when we have applied our budget per project. It appears cca 40 days . In the screenshot you can see the last column for this date(just for one project). Now i would like to make columns from those values like 2021August,2021September,2021October....

I would like to have those values on one row.One Project should be one row.

Desired output:

Project              August2021          September2021

1                               10k                               10k

 

Anyone has any idea how to solve it?

Preview file
389 KB
725 Views
1 Reply
VKadipakam
Contributor II
Contributor II
‎2021-07-26 12:08 PM

Hi

=monthname(Budget_applied_date)

Hope it helps.

VK

673 Views