Skip to main content

Qlik Community

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: 

New to Qlik Sense

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

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
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: 
Not applicable
‎2016-03-18 01:10 PM

Formatar grafico de linhas

Boa Tarde

Estou criando um gráfico de linha onde nas "Dimensões" preciso separar por mês e ano( ex. dez2015, jan2016) só que esta delimitando somente por mês e agrupando os valores.

estou usando: =month([campo]), qual seria a formula para delimitar por mês e ano

obs.: o campo e no formato dd/mm/aaaa

Preview file
43 KB
215 Views
0 Likes
1 Solution

Accepted Solutions
maxgro
MVP
MVP
‎2016-03-18 03:56 PM

like this?

1.png

use a calculated dimension

=date(monthstart(campo), 'MMMYYYY')

View solution in original post

137 Views
2 Replies
maxgro
MVP
MVP
‎2016-03-18 03:56 PM

like this?

1.png

use a calculated dimension

=date(monthstart(campo), 'MMMYYYY')

138 Views
Not applicable
‎2016-03-18 04:39 PM
Author

In response to maxgro

Isto mesmo!!! Muito Obrigado!!!!

137 Views
0 Likes