Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New 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
Honored Contributor 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
Honored Contributor 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
New 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
Honored Contributor 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
New Contributor II

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

Thank you very much.. It working perfectly.