Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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

Tags (1)
7 Replies
MVP
MVP

Re: Grouped Dimension in Line chart

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

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

Not applicable

Re: Grouped Dimension in Line chart

Thanks Manish..for the reply.

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

sujeetsingh
Honored Contributor III

Re: Grouped Dimension in Line chart

Reena,

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

MVP
MVP

Re: Grouped Dimension in Line chart

Create Calculated Dimesion

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

Remove Year and Month from your diemnsion.

Re: Grouped Dimension in Line chart

add two calculated dimensions

Year(Date)

month(Date)

MVP
MVP

Re: Grouped Dimension in Line chart

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

Untitled.png

Not applicable

Re: Grouped Dimension in Line chart

i hope the below Qvw file is helpful to you !