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.