topic Need Combined expressions for Line chart in QlikView

Need Combined expressions for Line chart

paolojolly — Thu, 11 Sep 2014 14:46:49 GMT

Hi, I have the following two graphs

with Month-Year and Item as dimensions for each of the two graphs and in which for each item I have a line with a different color

If I try to combine the graphs and to create a single graph using GRO PRI and NET PRI as expressions

I have the follow result

in which I lose the item group.

I need to have for each item different line (one for net pri and one for gro pri) and using diffent color to identify the different items

Can someone help me?

Thanks

Re: Need Combined expressions for Line chart

vgutkovsky — Thu, 11 Sep 2014 15:22:49 GMT

That's a really complex requirement...take a look at the attached. That's one way to accomplish what you need.

Regards,

Vlad

Re: Need Combined expressions for Line chart

paolojolly — Fri, 12 Sep 2014 09:28:23 GMT

Thanks for your reply. I have another problem, sometimes the chart does not return me any results and I do not understand why.

I attach the document

Can you help me? Thanks so much

Re: Need Combined expressions for Line chart

vgutkovsky — Sun, 14 Sep 2014 03:35:50 GMT

Try to modify your data model to get rid of that synthetic key. Also, create the Month-Year field in the data model instead of as a calculated dimension. If the problem still persists then, repost the new application and I'll try to take a look.

Regards,

Vlad

Re: Need Combined expressions for Line chart

paolojolly — Mon, 15 Sep 2014 13:50:38 GMT

I solved the problem by adding text () function in the expression

many thanks for your cooperation

Regards,

Paolo