Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

how to eliminate overlapping of values on Bar graphs?

I have horizontal bar graphs with percentages and values I want to see,

Bar Adjacent tobar corresponding values and beside that in braces percentage.

Exmaple: Bar 2942(%increment)

using this in one expression Im getting the values down to the other But I need adjacent to each other,

Dual(Chr(10)&Chr(10)&Chr(10)&Expression1,Expression1)

Please suggest me.

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: how to eliminate overlapping of values on Bar graphs?

Hi,

See Attachment.

See 'Variation' Expression Modified.

You can modify according to Your preferences.

Regards,

Antonio

View solution in original post

4 Replies
Highlighted
Master III
Master III

Re: how to eliminate overlapping of values on Bar graphs?

Hi,

See Attachment.

See 'Variation' Expression Modified.

You can modify according to Your preferences.

Regards,

Antonio

View solution in original post

Highlighted
Contributor II
Contributor II

Re: how to eliminate overlapping of values on Bar graphs?

Thank you very much for the quick reply,

could you please post the expression here, I could not ope the document .

Thank you

Highlighted
Master III
Master III

Re: how to eliminate overlapping of values on Bar graphs?

dual(Num((count( {<source = {'Sheet2'}>} [Complaint #])-count( {<source = {'Sheet1'}>} [Complaint #]))/(count( {<source = {'Sheet2'}>} [Complaint #])),'▲ #.##%; ▼ -#.##%'),count( {<source = {'Sheet2'}>} [Complaint #])*1.1)

Highlighted
Contributor II
Contributor II

Re: how to eliminate overlapping of values on Bar graphs?

Thank you very much.. It working perfectly.