Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

gangireddy
New Contributor

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
antoniotiman
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

4 Replies
antoniotiman
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

gangireddy
New Contributor

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

antoniotiman
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)

gangireddy
New Contributor

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

Thank you very much.. It working perfectly.

Community Browser