Create combo chart from pivot table.

[Anonymous]

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

[hemanthaanichet · Accepted solution]

split your expression that will get you the exact output

pls find the attachment below

[Anonymous]

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

[hemanthaanichet]

Adam , Slightly increase or expand the width of the chart

[Anonymous]

oo okay I see..

Thank you very much for your help, hemanth .

Regards,

Adam Ginza