topic Re: Chart taking too long time in QlikView

Chart taking too long time

bharatkishore — Thu, 21 Dec 2017 12:13:54 GMT

Hi All,

I have a combo chart and i have a written a calculated dimension which is given below:

=IF(not Match($(v_DB_Name),'CNT_PNT','CNT_REV'),

ProductGroup_SDE,ProductGroup)

But the problem is the chart is taking too much of time too load.

Is there any work around that it can be written in set analysis.

If so please let me know.

Thanks,

Bharat

Re: Chart taking too long time

sunny_talwar — Thu, 21 Dec 2017 12:25:40 GMT

What is v_DB_Name? A field of expression?

Re: Chart taking too long time

bharatkishore — Thu, 21 Dec 2017 12:35:15 GMT

Hi Sunny,

Yes, I have some text objects say for example,:

A and B

IF user clicks A (V_DB_Name shows A, if users selects B the V_DB_Name shows B).

Please let me know if you need anything more

Re: Chart taking too long time

sunny_talwar — Thu, 21 Dec 2017 12:36:34 GMT

It might be possible, but will have to look at some data... would you be able to provide a sample?

Re: Chart taking too long time

bharatkishore — Thu, 21 Dec 2017 13:01:57 GMT

Hi Sunny I have maximum erased the data but still it is 28MB.

Can i load top 20 records n send or if there is any other way let me know.

Thanks,

Bharat

Re: Chart taking too long time

sunny_talwar — Thu, 21 Dec 2017 13:03:44 GMT

I usually prepare a sample using the instructions on this link

Preparing examples for Upload - Reduction and Data Scrambling

Re: Chart taking too long time

bharatkishore — Thu, 21 Dec 2017 13:16:12 GMT

Hi Sunny,

Thanks for reply.

I already tried this then only it is 25MB.

Now there is no calculated dimension.

Please copy this expression in the dimension.

Thanks,

Bharat

Re: Chart taking too long time

bharatkishore — Thu, 21 Dec 2017 13:16:59 GMT

Sorry please use this expression:

=IF(not Match($(v_DB_Name),'CNT_PNT','CNT_REV'),

System_SDE,System)

Re: Chart taking too long time

sunny_talwar — Thu, 21 Dec 2017 13:22:18 GMT

Sure