Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month Year dimension displayed as a month

hi bit stuck here !

I have a pivot table which is meant to show the last 13 months of data so Dec 2014- Dec 2015

The thing is I need the headers to show the months without the year, but its grouping the value for Dec 2014 and Dec 2015 together (attached an example )

Anyone got any ideas how I can meet this requirement ?

Thanks

Sarah

1 Solution

Accepted Solutions
sunny_talwar

Try this as your calculated dimension:

=Dual(Left(Month_Year,3), Date#(Month_Year, 'MMM YYYY'))


Capture.PNG

View solution in original post

5 Replies
sunny_talwar

Try this as your calculated dimension:

=Dual(Left(Month_Year,3), Date#(Month_Year, 'MMM YYYY'))


Capture.PNG

View solution in original post

Not applicable
Author

Perfect thank you Sunny !

Not applicable
Author

Try like below:

LOAD

  * ,

  Num(Date#(Month_Year,'MMMM YYYY')) AS Month_YRDate,

  Left(Month_Year,3) AS Month_Name

INLINE [

Month_Year,ID

Dec 2014, 1

Jan 2015, 1

Feb 2015, 1

Mar 2015, 1

Apr 2015, 1

May 2015, 1

Jun 2015, 1

Jul 2015, 1

Aug 2015, 1

Sep 2015, 1

Oct 2015, 1

Nov 2015, 1

Dec 2015,1

];

Create calcualted diemension like below:

Dual(Month_Name,Month_YRDate)

sunny_talwar

No problem

Not applicable
Author

attached qvw file.