Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor II

Re: Type of chart

14 Replies
Honored Contributor III

Re: Type of chart

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

Highlighted
MVP
MVP

Re: Type of chart

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

Please check enclosed file..

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

Highlighted
Partner
Partner

Re: Type of chart

HI,

See the attachment.

Highlighted
Not applicable

Re: Type of chart

Henric Cronström

Steve Dark

Miguel Angel Baeyens

Hello Tech Geniis,

need your precious guidance.

Thanks and best regards

SAK

Highlighted
Valued Contributor III

Re: Type of chart

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Type of chart

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

Highlighted
Valued Contributor II

Re: Type of chart

Hi,

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

Pls check

-Sundar

Highlighted
Not applicable

Re: Type of chart

Hi Sundar,

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

Thanks

Shoaib

Highlighted
Valued Contributor II

Re: Type of chart

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