Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview Masters,
Greetings.
I have a Pivot Table which consists of 2 similar Expressions. The only difference is in one of the set analysis.
The first expression has FACT_SKU = 'SPPD', and the other one has FACT_SKU = 'ND %' in it.
Here is the sample screen shot of my pivot table.
My goal is to create a combo chart which looks similar to this.
I have tried to convert my previously shown pivot table into a combo chart. However, it just didn't look like the same.
Here's my converted pivot table into combo chart.
Where did I do wrong?
If making the combo chart that looks exactly the same as the sample chart is impossible, is there any workaround I can do?
Please find the attached QVW as the sample.
This issue has been bugging me for the last 2 days.
Any kind of help would be much appreciated.
Thanks in advance.
Regards,
Adam Ginza
split your expression that will get you the exact output
pls find the attachment below
split your expression that will get you the exact output
pls find the attachment below
Hi hemanth,
Thank you for your reply.
However, the proposed solution is almost correct, but the 16PRO doesn't show up in the legend.
For additional info, I'm trying to create a combo chart that represents the selected SKU_CODE(16PRO) vs the COMPETITOR_SKU_CODE (16FS). That is why in my set analysis I used "+" to compare the selected SKU_CODE and also its competitor. Because the SKU_CODE column and COMPETITOR_SKU_CODE column are from 2 different table. And if I joined both of the column, the result would be duplicated, since the relationship between those 2 tables is 1 to Many.
Is there maybe any other workaround for this?
Thanks.
Regards,
Adam Ginza
Adam , Slightly increase or expand the width of the chart
oo okay I see..
Thank you very much for your help, hemanth .
Regards,
Adam Ginza