Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouped Dimension in Line chart

Hi All,

Is it Possible to create a grouped dimension of month and year as shown below in line chart??

Capture.PNG

Please help.

Regards,

Reena

8 Replies
MK_QSL
MVP
MVP

Yes... Create MonthYear in your script and use it in your line table dimension

Date(MonthStart(YourDateField),'MMM-YYYY') as MonthYear

Not applicable
Author

Thanks Manish..for the reply.

Other than that is it possible to create a UI similar to the chart attched.. ?

sujeetsingh
Master III
Master III

Reena,

Derive Year,Month and then try playing at UI you may get a similar representation .

MK_QSL
MVP
MVP

Create Calculated Dimesion

=Date#(Month& '-' & Year,'MMM-YYYY')

Remove Year and Month from your diemnsion.

Kushal_Chawda

add two calculated dimensions

Year(Date)

month(Date)

tresesco
MVP
MVP

Please find the attached sample. Credit to JohnW‌ (one of the better contributors)

Untitled.png

Not applicable
Author

i hope the below Qvw file is helpful to you !

brandk
Contributor III
Contributor III

Hi, is there a way I can convert this to Qliksense compatible file