Solved: column name as a month & Year - Qlik Community

Anonymous · ‎2017-12-08

hello

i want month as well as year in column name. i tried many exp in label but its not working .

Thank You..

Anil_Babu_Samineni · ‎2017-12-08

I know, that is from paint.

Usually, In label we call call it as =MonthName(Max(FieldName))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Anil_Babu_Samineni · ‎2017-12-08

Not sure, What does this showcase of Label? Is there any logic?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Chanty4u · ‎2017-12-08

can yougive some sample data ?

whcih object you are trying?

Anonymous · ‎2017-12-08

post the sample data with expected result sample

Anonymous · ‎2017-12-08

straight table

Anonymous · ‎2017-12-08

i did it in paint.

Anil_Babu_Samineni · ‎2017-12-08

I know, that is from paint.

Usually, In label we call call it as =MonthName(Max(FieldName))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Chanty4u · ‎2017-12-08

you can give each expression with your format label?

Anonymous · ‎2017-12-08

Try this ....Month(Date)&'-'&Year(Date)

Assuming :

Take a pivot table with add ur dimensions which includes your date dimension(use the above logic) and add ur expressions. Now drag this date dimension to the top to see them as columns... jan-2016 feb-2016 and so on..

Colin-Albert · ‎2017-12-08

Use the monthname() function on your date as a dimension.

Either use a calculated dimension monthname(YourDateField) or create a monthname field in your load script.