Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Go to Solution.
That's a really complex requirement...take a look at the attached. That's one way to accomplish what you need.
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
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.
I solved the problem by adding text () function in the expression
many thanks for your cooperation