Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Limiting dimension based on reference lines and expression

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.

 

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Re: Limiting dimension based on reference lines and expression

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.

View solution in original post

5 Replies
Highlighted
Specialist II
Specialist II

Re: Limiting dimension based on reference lines and expression

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

regards

 
 
 
 
Highlighted
Creator
Creator

Re: Limiting dimension based on reference lines and expression

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.

Highlighted
Specialist II
Specialist II

Re: Limiting dimension based on reference lines and expression

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

then it should solve both of your coniditions.

regards

Highlighted
Creator
Creator

Re: Limiting dimension based on reference lines and expression

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

Highlighted
Creator
Creator

Re: Limiting dimension based on reference lines and expression

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.

View solution in original post