Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
adamginza
Contributor
Contributor

Create combo chart from pivot table.

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.

Pivot Table sample.PNG

My goal is to create a combo chart which looks similar to this.

Combo1.PNG

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.

Result Combo Chart.PNG

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

1 Solution

Accepted Solutions
hemanthaanichet
Creator III
Creator III

split your expression that will get you the exact output

pls find the attachment below

View solution in original post

4 Replies
hemanthaanichet
Creator III
Creator III

split your expression that will get you the exact output

pls find the attachment below

View solution in original post

adamginza
Contributor
Contributor
Author

Hi hemanth,

Thank you for your reply.

However, the proposed solution is almost correct, but the 16PRO doesn't show up in the legend.

PropSol1.PNG

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
Creator III
Creator III

111.PNG

Adam , Slightly increase or expand the width of the chart

adamginza
Contributor
Contributor
Author

oo okay I see..

Thank you very much for your help, hemanth .

Regards,

Adam Ginza