7 Replies Latest reply: Feb 19, 2013 8:12 AM by Venkat Venkat RSS

Performance issue in LineChart

Venkat Venkat

Hi qlikview team,

 

Currently facing big problem on performance in web browser.

 

My present application size is 3.5 GB. Now in app having "TimeSeries" sheet containing LineChart with 1 dimension and 7 expression as below :

 

CaptureTimeSPCRange is a  variable in "Slider Object" having time intervals 5,10,15,....60.

 

Is there any way to improve performance and make faster in selections ?

 

Dimension :

 

=Date(CaptureDateTime,'M/D/YY')&' '&Pick(WildMatch(CaptureTimeSPCRange,'5','10','15','20','25','30','35','40','45','50','55','60'),[5mins],[10mins],[15mins],[20mins],[25mins],[30mins],[35mins],[40mins],[45mins],[50mins],[55mins],[60mins])

 

 

Expressions :

 

1.)LotNo

='Lot = ' & LotNo

 

2.)Defective Lens Rate

1000000*count({$<LensResult={"Fail"}, DefectStatus= {"Fail"} >} DISTINCT LensKey)

/count({$ <LensResult={"Fail","Pass"}, DefectStatus = {"Fail","Pass"}, [Defect Name] =>} DISTINCT LensKey)

 

3.)LensCount

count({$ <[Defect Name] = >} DISTINCT LensKey)

 

4.)Avg

1000000*count( {$<LensResult={"Fail"}, DefectStatus= {"Fail"}>} Distinct Total LensKey)

/count({$ <LensResult={"Fail","Pass"}, DefectStatus = {"Fail","Pass"}, [Defect Name] =>} DISTINCT TOTAL LensKey)

 

5.)UCL

=Avg. + Mediandiff/MediantoSconversion * 3

 

6.)LCL

if((Avg. - Mediandiff/$(MediantoSconversion) * 3) < 0, .00001, (Avg. - Mediandiff/$(MediantoSconversion) * 3)  )

 

7.)Mediandiff

median ( Total aggr( 1000000*(fabs(count({$<LensResult={"Fail"}, DefectStatus= {"Fail"} >} DISTINCT LensKey)

/count({$ <LensResult={"Fail","Pass"}, DefectStatus = {"Fail","Pass"}, [Defect Name] =>} DISTINCT LensKey)

-

count({$<LensResult={"Fail"}, DefectStatus= {"Fail"} >} DISTINCT Total LensKey)

/count({$ <LensResult={"Fail","Pass"}, DefectStatus = {"Fail","Pass"}, [Defect Name] =>} DISTINCT Total LensKey))), LotNo ))

 

 

Highly appreciated your ideas on this.

 

Thanks in advance.