Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it Possible to create a grouped dimension of month and year as shown below in line chart??
Please help.
Regards,
Reena
Yes... Create MonthYear in your script and use it in your line table dimension
Date(MonthStart(YourDateField),'MMM-YYYY') as MonthYear
Thanks Manish..for the reply.
Other than that is it possible to create a UI similar to the chart attched.. ?
Reena,
Derive Year,Month and then try playing at UI you may get a similar representation .
Create Calculated Dimesion
=Date#(Month& '-' & Year,'MMM-YYYY')
Remove Year and Month from your diemnsion.
add two calculated dimensions
Year(Date)
month(Date)
Please find the attached sample. Credit to JohnW (one of the better contributors)
i hope the below Qvw file is helpful to you !
Hi, is there a way I can convert this to Qliksense compatible file