topic Re: x axis on bar chart in QlikView

x axis on bar chart

manoranjan_d — Wed, 13 Jul 2016 10:15:27 GMT

Hi,

I m using dollar list box of billions,million, thousand

where the value is

=If(amt='Millions', 1000000,

If(amt='Thousands', 1000,

If(amt='Billion', 100000000,1)))

its assigned to the vAmt variable

now i m using the bar chart

dimension as

MSG field is used

expression as

=sum(spnd )/vAmt

now my issue is when ever i select the thousand or billions or millions in list box, my bar chart x axes should always show the gap interval of 5 10 15 in the x axis to all the list box which select in dollar list box,

when ever i select the millions or billions or thousnand the gap interval in the x axis is getting differ

for example for billions 0.0000 0.0005 0.0010 0.0015

for millions 0.00 0.05 0.10 0.15

for thousand 0 50 100 150

so need this gap interval always to be same as 5 10 100 for any selection in dollar list box

Re: x axis on bar chart

rubenmarin — Wed, 13 Jul 2016 10:34:14 GMT

Hi, If your example for billions has left a '0' (0.00005 instead of 0.0005) you can use the 'static increment' in the axis tab, the increment can be:

=50000/vAmt

Re: x axis on bar chart

manoranjan_d — Wed, 13 Jul 2016 10:48:35 GMT

can u put me screen shot for this

Re: x axis on bar chart

manoranjan_d — Wed, 13 Jul 2016 10:49:30 GMT

statuc i have staic min and static max

Re: x axis on bar chart

rubenmarin — Wed, 13 Jul 2016 10:51:38 GMT

I don't have data but I'm tlaking of this:

Re: x axis on bar chart

kaushiknsolanki — Wed, 13 Jul 2016 10:57:58 GMT

Here is the image.

Regards,

Kaushik Solanki