topic bar chart? req in QlikView

bar chart? req

Fri, 15 Aug 2014 08:18:29 GMT

pls find attached and i want reduce bar size based on req

2000- i want see upto 500 like wise all but in data base should not change

jagan — Fri, 15 Aug 2014 08:22:44 GMT

Hi,

Try in Chart Properties-> Axes -> And give Static Min and Max values 0 and 500.

If this is not you are expecting explain in detail with some example.

Regards,

Jagan.

MK_QSL — Fri, 15 Aug 2014 08:23:23 GMT

What is the logic you want ?

Here you are reducing 2000 by 500 and all other by 1000...

You can achieve the same by

Expression

Click on + Sign of SUM(SALES)

Bar Offset

Write below expression

IF(Year = 2000,-500,-1000)