topic Re: Table with conditional data bars in QlikView

Table with conditional data bars

Fri, 09 Nov 2012 15:38:53 GMT

Hi,

I'm trying to recreate the very same table in QlikView:

and this is what I've got so far:

These are 2 overlaying bar charts with different layer settings and 2 text boxes on top of them. The Pyjama Blue style as a background is missing and the values are not aligned to the right. How can I fix these issues?

Regards,

Ivelin

Re: Table with conditional data bars

shree909 — Fri, 09 Nov 2012 15:56:28 GMT

Hi ,

How about plotting the datapoints inside the bar, may be that can align the values exactly..

Re: Table with conditional data bars

Fri, 09 Nov 2012 15:59:58 GMT

Hi,

I tried that but it just moves the values a little to the left and I want them all aligned to the right, as they are in the excel.

Re: Table with conditional data bars

MayilVahanan — Fri, 09 Nov 2012 16:07:29 GMT

It display the data above the top of the bar only..We can't able to align the values in the right side

Re: Table with conditional data bars

johnw — Fri, 09 Nov 2012 22:25:19 GMT

Here's fairly close using just a single chart. I couldn't fix the title line colors because doing a custom format cell on that row was crashing my QlikView. I wasn't sure if you wanted the size of the download bars to be on the same exact scale as the visitors bars, so that they would be visually comparable, but that's what I did. If you want a separate scale for the downloads bars, edit the max expression in the gauge properties and replace Visitors with Downloads.

Re: Table with conditional data bars

Mon, 12 Nov 2012 09:42:10 GMT

Thanks John!