Line chart Question

[#1]

Is it possible to create a line chart in Qlikview similar to the attached Excel file?

One of the lines only shows symbol because some data points are null.

Thanks.

[#2]

Hi,

I feel, we don't have the option to show some dimension's by LIne and some are by symbols. So, you have to use multiple expressions depends on number of dimensions. You probably knew what I meant for. But, anyway see the attachment.

[#3]

Hi Venugopal,

You have used separate experssion for each category.

Is it possible to use two expressions, one for Category C and the other expression for the rest of categories? Thanks.

[#4]

Hi,

Yes that is possible. Modify the set expression accordingly.

[#5]

I've tried to modify the set expression but the chart is not shown as expected.

It groups all other categories in one line but I want to show each category separately on the line chart.

I've attached my modified qlikview file. Would you please advise?

[jagan]

Hi,

Please find attached file for solution, hope this is what you are expecting.

Regards,

Jagan.

[#7]

I also want to show one of the categories by symbol instead of line. Is it possible?

[jagan]

Hi,

I think it is not possible, but you can differentiate the Line from others.  Please find attached file.

Regards,

Jagan.