Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
manoranjan_d
Contributor II

x axis on bar chart

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

   

5 Replies

Re: x axis on bar chart

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

manoranjan_d
Contributor II

Re: x axis on bar chart

can u put me screen shot for this

manoranjan_d
Contributor II

Re: x axis on bar chart

statuc i have staic min and static max

Re: x axis on bar chart

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

1.jpg

Re: x axis on bar chart

Hi

Here is the image.

Regards,

Kaushik SolankiCapture.PNG