Discussion Board for collaboration related to QlikView App Development.
Is it Possible to create a grouped dimension of month and year as shown below in line chart??
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.. ?
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
Please find the attached sample. Credit to JohnW (one of the better contributors)
i hope the below Qvw file is helpful to you !