topic Re: Type of chart in QlikView

Type of chart

Thu, 20 Mar 2014 10:35:07 GMT

Hi all,

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

BR,

SAK

Re: Type of chart

amit_saini — Thu, 20 Mar 2014 10:40:59 GMT

Hi Shoaib,

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

Thanks,

Re: Type of chart

MK_QSL — Thu, 20 Mar 2014 11:05:04 GMT

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

Please check enclosed file..

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

Re: Type of chart

jsingh71 — Thu, 20 Mar 2014 11:13:54 GMT

HI,

See the attachment.

Re: Type of chart

Thu, 20 Mar 2014 11:58:46 GMT

Henric Cronström

Steve Dark

Miguel Angel Baeyens

Hello Tech Geniis,

need your precious guidance.

Thanks and best regards

SAK

Re: Type of chart

sudeepkm — Thu, 20 Mar 2014 12:35:27 GMT

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

Re: Type of chart

stevedark — Thu, 20 Mar 2014 13:25:15 GMT

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

Re: Type of chart

sundarakumar — Fri, 21 Mar 2014 07:51:30 GMT

Hi,

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

Pls check

-Sundar

Re: Type of chart

Fri, 21 Mar 2014 12:22:11 GMT

Hi Sundar,

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

Thanks

Shoaib

Re: Type of chart

sundarakumar — Fri, 21 Mar 2014 12:27:42 GMT

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

Re: Type of chart

sundarakumar — Fri, 21 Mar 2014 12:33:17 GMT

Re: Type of chart

Fri, 21 Mar 2014 22:33:32 GMT

Great! Achieved after making bar distance Zero in Presentation tab.

One more thing! In expression tab, if i check 'values on data points' in first sum(sales) expression, it's giving correct. But if I check the same for 2nd TOTAL expression, it's giving three totals, though i need one. for example, in Jan month, I need 620 on top of gray bar.

Thanks a lot! dear.

BR,

SAK

Re: Type of chart

Fri, 21 Mar 2014 22:44:21 GMT

Yahoo! done.Sundarakumar Kalaimani

I used Combo chart. First two expressions with bar. third expression with symbol (plus) with formula SUM(TOTAL<Month>Sales).

But if you have one product selected in the list, the lining up of two 'Values on Data points' was not good as pointed by Steve Dark.

However, to avoid lining up issue I made third expression conditional as =GetSelectedCount(Product)=0 or GetSelectedCount(Product)>1.

In the end, it all worked great.

Thanks a lot!

Re: Type of chart

Fri, 21 Mar 2014 23:11:30 GMT

In presentation tab, unchecked pop-up labels, as really there is no need for it as everything is labelled itself - month, product name, each product monthly sale, and total monthly sale; otherwise natural pop up does not look proper (especially for 2nd expression).

Re: Type of chart

sundarakumar — Mon, 24 Mar 2014 05:20:39 GMT

You are welcome