Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Type of chart

Hi all,

Is this type of chart possible? Blue is Product 'A' sales and Green Product 'B' sales, whereas Grey is total sales.

chart.png

BR,

SAK

1 Solution

Accepted Solutions
14 Replies
amit_saini
Master III
Master III

Hi Shoaib,

Please go to the chart properties---->>> Under Style Tab you can try this by changing Top Angle and Side Angle Dimensions.

Thanks,

AS

MK_QSL
MVP
MVP

Not exactly matched your requirements but tried to go near..

Please check enclosed file..

UPDATE : Bit more near... check 2nd file..

jsingh71
Partner - Specialist
Partner - Specialist

HI,

See the attachment.

Not applicable
Author

Henric Cronström

Steve Dark

Miguel Angel Baeyens

Hello Tech Geniis,

need your precious guidance.

Thanks and best regards

SAK

sudeepkm
Specialist III
Specialist III

Please take a look at the chart. May be two charts with transparent mode can bring such visualization.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Whilst layering transparent charts is possible it tends to get very confusing very quickly - and sometimes the lining up fails.

You could use a combo chart and put a symbol above the bars to show the total (you would need to use the TOTAL <Dim> syntax to ignore the second dimension).  Another way to achieve similar may be to have a stacked bar, where you have the DimValue as one expression then the Total (using TOTAL again) less the dimension value as expression two then stack them.  I'm not sure whether stacked bars and multi dimensions play nicely together though.

It's always worth trying to push back to the end user to get them to have something a bit more standard, if you can.

Steve

sundarakumar
Specialist II
Specialist II

Hi,

I have edited Manish's Chart a little it and it looks exactly as what u want..

Pls check

-Sundar

Not applicable
Author

Hi Sundar,

I have PE version. Can you please paste here screen shots.

Thanks

Shoaib

sundarakumar
Specialist II
Specialist II

In script

Load * Inline

[

Month, Product, Sales

Jan, A, 200

Jan, B, 300

Jan, C, 120

Feb, A, 420

Feb, B, 360

Feb, C, 220

Mar, A, 180

Mar, B, 300

Mar, C, 420

Apr, A, 600

Apr, B, 400

Apr, C, 220

]
;

Create a bar cahrt with Month and Product as Dimension

In expression create two expressions

1.sum(Sales)

2. (TOTAL <Month> Sales)-sum(Sales)

for expression 1. background color

If(Product = 'A', Green(),

If(Product = 'B', Blue(),

If(Product = 'C', Red())))

 

In the color tab keep first three colors as light grey..

-Sundar