topic Re: Chart Properties - Forced 0 properties in QlikView

Chart Properties - Forced 0 properties

laujerry — Mon, 19 Oct 2015 10:02:42 GMT

Hi all

any one know how this option works?

i have a bar chart with all positive values, but the bar just "flows" over the zero level

i need to check the "forced 0" option to let them "sit" on the zero

so what does this phenomenon tell? any insight can tell from this?

thanks

Re: Chart Properties - Forced 0 properties

avinashelite — Mon, 19 Oct 2015 10:11:50 GMT

Force 0 is to tell Qlikview that your Y axis display should always start from 0 as the first value. If you don't check this option the values will start from the Qlikview internal calculated value , eg if you have 10values to display in a bar chart and all the values from 200 to 1000 than every values is greater than 200 so Qlikview will dynamically assign 200 as the base start point to avoid this we will use this option

Re: Chart Properties - Forced 0 properties

laujerry — Mon, 19 Oct 2015 10:19:03 GMT

hi Avinash,

my chart is composed of a month(-year) dimension against a summation of certain value

the flow-over effect only appears when i select certain year and month (e.g. 2015 Jan)

so in my case, does it mean that my value data set contains negative values in the period 2015 Jan?

thanks

Jerry

Re: Chart Properties - Forced 0 properties

avinashelite — Mon, 19 Oct 2015 10:23:34 GMT

it would be hard to say without the seeing the file, can you please share the app

Re: Chart Properties - Forced 0 properties

laujerry — Mon, 19 Oct 2015 12:53:47 GMT

sorry, i cannot share the app to public, thanks

Re: Chart Properties - Forced 0 properties

avinashelite — Mon, 19 Oct 2015 12:58:43 GMT

OK np, as per your words . I feel you might not have the data or the aggregation is getting set only for that values.