Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Performance issue in LineChart

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.

7 Replies
danielrozental
Honored Contributor II

Re: Performance issue in LineChart

Just to get you started, avoid calculated dimensions at any cost.

Not applicable

Re: Performance issue in LineChart

hi Daniel,

Thanks for reply.

Actually my dimension will be changed based on selected value in Slider object.

Ex 1: if my slider set to 5 then dimension should be as follows:

Date(CaptureDateTime,'M/D/YY')&' '&[5 Mins]

Ex 2: if my slider set to 10 then dimension should be as follows :

Date(CaptureDateTime,'M/D/YY')&' '&[10 Mins]

So whatever the user selected value in slider object is currently taken as dimension filed as follows and here CaptureTimeSPCRange is the variable name for the slider object.

=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])

Is there any other better way to avoid this calculated dimension and also should work  same as above dimension.

Please let me know the better solution to avoid performance issue.

thanks in advance.

danielrozental
Honored Contributor II

Re: Performance issue in LineChart

Create a new dimension, something like this

img13.png

Not applicable

Re: Performance issue in LineChart

hi Daniel,

Sorry for late reply.

I tried to achieve what you said in creating new dimension but  bad i didn't reached properly.

Can you please find the attached sample file and let me know how and where i can create a  new dimension in this.

Thanks in advance.

Not applicable

Re: Performance issue in LineChart

Hi,

Still waiting for solution in increasing  performance in line chart .

Any help on this great appreciated.

Thanks in advance.

jerrysvensson
Valued Contributor II

Re: Performance issue in LineChart

Can see any increase if you remove the Date function from  : Date(CaptureDateTime,'M/D/YY')

Do you have to format it? Can't you format the data used in CaptureDateTime in the script?

Not applicable

Re: Performance issue in LineChart

hi jerry svenson,

thanks for reply.

I'm not sure this might work in increasing the performance, but i will cross check and let you know by removing timestamp in dimension.

Thanks in advance.