Grouped Dimension in Line chart

[#1]

Hi All,

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

Please help.

Regards,

Reena

[MK_QSL]

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

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

[#3]

Thanks Manish..for the reply.

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

[sujeetsingh]

Reena,

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

[MK_QSL]

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)

[tresB]

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

[#8]

i hope the below Qvw file is helpful to you !

[brandk]

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