topic Stacked Bar Chart in QlikView

Stacked Bar Chart

manishkumar75 — Fri, 01 May 2009 11:53:25 GMT

Is it possible to put dynamic Image in the Chart (like Text) ? Actually, I need to show the margin of revenue in stacked bar chart comparing with previous year.

Stacked Bar Chart

Fri, 01 May 2009 13:46:46 GMT

I don't think that is possible, like the the name tells "Text in Chart". I never noticed an option to define this text as image. Maybe you can use an icon/symbol in the chart that belongs to a fonttype to achieve the same result.

Stacked Bar Chart

manishkumar75 — Fri, 01 May 2009 17:53:54 GMT

Hi Mark,

I do agree with your view. I have to try some other alternative.

Thanx

Manish

Stacked Bar Chart

rwunderlich — Sat, 02 May 2009 00:16:58 GMT

You can overlay a text object with image on the chart to possibly get the effect you need.

-Rob

Stacked Bar Chart

manishkumar75 — Mon, 04 May 2009 14:35:59 GMT

Hi Rob,

Can you please tell me , how to acheive this ?

Thanks,

Manish

Stacked Bar Chart

rwunderlich — Tue, 05 May 2009 00:58:28 GMT

Are you trying to add another bar that shows the difference? How about using a reference line?

Stacked Bar Chart

manishkumar75 — Tue, 05 May 2009 11:27:41 GMT

Hi Rob,

I want to show the difference as depicted in the attached image.

Thanks

-Manish

Stacked Bar Chart

johnw — Tue, 05 May 2009 23:35:41 GMT

See the attached example. There are three text boxes overlayed on the chart. And UP box, a DOWN box, and the amount it is up or down. The UP box is only displayed if it is up or steady. The DOWN box is only displayed if it is down. To overlay images, simply replace the text in the UP and DOWN boxes with images on the General tab of the text box.

Stacked Bar Chart

manishkumar75 — Wed, 06 May 2009 11:51:34 GMT

Thanks John,

This is what, I want to do.

- Manish

Stacked Bar Chart

manishkumar75 — Wed, 06 May 2009 13:22:30 GMT

Hi John,

I am also exporting the Chart Image to Excel using the following Macro :

Sub ExportImg

set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
set XLDoc = XLApp.Workbooks.Add
ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard
XLApp.Worksheets(1).Range("A1").Select()
XLApp.Worksheets(1).PasteSpecial

End Sub

Now , when three text boxes are added to chart, how can I Export these text boxes alongwith the chart.

Thanks,

Manish

Stacked Bar Chart

johnw — Wed, 06 May 2009 22:44:01 GMT

I don't do a lot of exporting, so I probably won't be much help. I'm guessing that you could detect which of the two images is visible, and then export it separately. I don't know if you can overlay images in Excel.

I think the right long-term solution would be a QlikView enhancement proposed by Rob Wunderlich - grouped objects. In this case, you would mark that the four pieces are grouped, and when you export an image, it would combine them all into a single image. But that doesn't exist yet.

Stacked Bar Chart

Fri, 21 May 2010 10:02:58 GMT

People i know this thread is old but please help if you can , I tried to run the macro posted and got this error

"ActiveX component can't create object: 'Excel.Application' "

DO i have to add some references in Qlikview to be able to reference the XL application

Please advise how i would get this code to work . I would then run a loop for each object to dump it to a different part of the spreadsheet

any advise appreciated

regards Pat

Stacked Bar Chart

manishkumar75 — Fri, 21 May 2010 10:27:02 GMT

Hi,

The above error is due to security . Just change the Current Local Security to Allow System Access.

In your case it is Only Safe Mode.

Hope it will work.

Regards,

Manish

Stacked Bar Chart

Fri, 21 May 2010 11:01:54 GMT

Manish , thank you - you have helped a RANK beginner worked perfectly