topic Re: Create combo chart from pivot table. in QlikView

Create combo chart from pivot table.

Anonymous — Wed, 22 Feb 2017 03:56:33 GMT

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

Re: Create combo chart from pivot table.

hemanthaanichet — Wed, 22 Feb 2017 05:41:39 GMT

split your expression that will get you the exact output

pls find the attachment below

Re: Create combo chart from pivot table.

Anonymous — Wed, 22 Feb 2017 06:36:44 GMT

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

Re: Create combo chart from pivot table.

hemanthaanichet — Wed, 22 Feb 2017 07:58:05 GMT

Adam , Slightly increase or expand the width of the chart

Re: Create combo chart from pivot table.

Anonymous — Wed, 22 Feb 2017 10:21:20 GMT

oo okay I see..

Thank you very much for your help, hemanth .

Regards,

Adam Ginza