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

Table with conditional data bars

Hi,

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

Table.png

and this is what I've got so far:

Table2.png

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

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

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.

BarsInChart.png

View solution in original post

5 Replies
shree909
Partner - Specialist II
Partner - Specialist II

Hi ,

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

Not applicable
Author

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.

MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
johnw
Champion III
Champion III

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.

BarsInChart.png

Not applicable
Author

Thanks John!