topic Re: Limiting dimension based on reference lines and expression in QlikView

Limiting dimension based on reference lines and expression

mtucholski — Sat, 16 Nov 2024 02:00:00 GMT

Hi,

I created a chart with class() defined dimension. Now I want to show the output but without showing irrelevant values. So the first thing I did was limiting the dimension to show only values accumulated to 99% of relative to the total. It will probably work with most cases but sometimes the values does not exceed the reference lines so those lines wont be visible.

What I want to do is to show the chart with 99% of the values but the reference lines should always be visible. So the chart should look like the first one from my example file where Z=A.

I Will apprecieate your help.

Re: Limiting dimension based on reference lines and expression

zhadrakas — Fri, 08 Nov 2019 08:24:16 GMT

try setting min & max values for your axis on presentation tab.

regards

Re: Limiting dimension based on reference lines and expression

mtucholski — Fri, 08 Nov 2019 08:52:56 GMT

Hi, thanks for the input but it wont work. You fulfilled only one condition while there is two of them.

Show 99% of the expression

AND

Show reference lines

Please check the third chart in my example file.

Re: Limiting dimension based on reference lines and expression

zhadrakas — Fri, 08 Nov 2019 08:56:21 GMT

you can set limit in dimension limit tab like you did in your first chart.

then it should solve both of your coniditions.

regards

Re: Limiting dimension based on reference lines and expression

mtucholski — Fri, 08 Nov 2019 09:01:06 GMT

No, it doesn't. Apparently the axis limits overrides dimension limits.

Did you manage to do it? Could you please share the qvw file?

Thanks

Re: Limiting dimension based on reference lines and expression

mtucholski — Fri, 08 Nov 2019 09:51:39 GMT

Ok, I have managed to find the solution.

I used axis scale limits with six sigma rule.

Static Min: if(avg(x)-3*Stdev(x)<0.2,avg(x)-3*Stdev(x),0.2)*0.9

Static Max: if(avg(x)+3*Stdev(x)>0.6,avg(x)+3*Stdev(x),0.6)*1.1

where 0.2 = LSL reference line and 0.6 = USL reference line

The 0.9 and 1.1 multiplier is to make sure that everything will be fully visible and readable.