topic Re: Refresh Time on charts while we change selections from list box in QlikView

Refresh Time on charts while we change selections from list box

kmswetha — Thu, 12 Feb 2015 10:40:49 GMT

Hi everyone,

Is there a way to decrease a refresh time of charts on UI when we change selections in list box.

I have 6 million records and it takes much time to refresh, say 10-15 seconds for every selection made?

Is there way to decrease the time?

Re: Refresh Time on charts while we change selections from list box

alexandros17 — Thu, 12 Feb 2015 10:43:29 GMT

Decrease the number of columns or make expressions more simply (if they are too complex)

In any case I use to diplay rows only when selections have been done, in condition display I add GetSelectedCount(myField)>0 in order to not to wait while I do selectionsl

Re: Refresh Time on charts while we change selections from list box

datanibbler — Thu, 12 Feb 2015 10:44:26 GMT

Hi,

I can think only of the long way - to hard-code the different possibilities in different diagrams, each with standard selections already built in and with corresp. visibility_conditions. But that would be re-inventing the wheel in a way.

Re: Refresh Time on charts while we change selections from list box

sagarkharpude — Thu, 12 Feb 2015 10:48:57 GMT

Hi,

U can improve the performance by following ways

1. Use Set analysis instead of if else condition

2. define the condition in backend script and use the flag of that in charts

3. Use Trigger while opening the conditions like current month,year always selected

Re: Refresh Time on charts while we change selections from list box

kmswetha — Thu, 12 Feb 2015 11:01:07 GMT

Hi Every one,

Calculations are pretty simple, sum(filed_name) and just two expressions. Where as dimensions are around 8.

Re: Refresh Time on charts while we change selections from list box

alexandros17 — Thu, 12 Feb 2015 11:02:20 GMT

So the only thing is to disable loadind (with the condition as I said before) then load only once you selected the field

Re: Refresh Time on charts while we change selections from list box

giakoum — Thu, 12 Feb 2015 11:05:01 GMT

see attached pdf that pretty much includes all that you have been suggested so far plus many more

Re: Refresh Time on charts while we change selections from list box

sagarkharpude — Thu, 12 Feb 2015 11:07:06 GMT

dimension are simple or calculated? if calculated list out please.

Re: Refresh Time on charts while we change selections from list box

kmswetha — Thu, 12 Feb 2015 11:10:03 GMT

Dimensions are pretty simple.No calculations.

Re: Refresh Time on charts while we change selections from list box

kmswetha — Thu, 12 Feb 2015 11:13:36 GMT

Should I put this in dimension? If not where should I put it?Its a pivot chart

Re: Refresh Time on charts while we change selections from list box

alexandros17 — Thu, 12 Feb 2015 11:19:20 GMT

This is my example

Re: Refresh Time on charts while we change selections from list box

kmswetha — Thu, 12 Feb 2015 11:38:48 GMT

Thanks for the example.But out of 8 dimensions show, only 2 are list box selections and those selections are of drill down and drill up..Looks like it will not help me correct me if am wrong

Re: Refresh Time on charts while we change selections from list box

alexandros17 — Thu, 12 Feb 2015 11:40:23 GMT

Could you share your doc?

Re: Refresh Time on charts while we change selections from list box

kmswetha — Thu, 12 Feb 2015 13:40:10 GMT

unfortunately I wouldn't be able to since would be working on remote.