Dear Qlikview Masters,
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.
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?