topic Re: Script Execution Is Not Fetching Data in QlikView

Script Execution Is Not Fetching Data

umartareen — Mon, 04 Jan 2016 07:42:00 GMT

Hi,

When I apply Group By clause after performing addition of two amount fields, the load is not fetching any tables.

The execution page appears to be like this:

I have to abort it in order to exit the execution and reload old data.

Any idea what is wrong ?

Thanks,

Umar

Re: Script Execution Is Not Fetching Data

tamilarasu — Mon, 04 Jan 2016 07:43:26 GMT

Could you post your script.?

Re: Script Execution Is Not Fetching Data

marcus_sommer — Mon, 04 Jan 2016 08:19:53 GMT

Aggregation loads with group by could take a loooong time and before qlikview isn't finish with its first grouping step it won't give a response - in conclusion: it's a normal behaviour (but take a look in taskmanager on the RAM consumption - such groupings need a lot of RAM and should qv swap into the virtual RAM it will be going very slow).

- Marcus

Re: Script Execution Is Not Fetching Data

HirisH_V7 — Mon, 04 Jan 2016 08:44:46 GMT

Hi,

Can you provide your sample script?!

-Hirish

Re: Script Execution Is Not Fetching Data

umartareen — Mon, 04 Jan 2016 09:45:25 GMT

Hi Everybody,

Thanks for the immediate response. Solved the issue myself.

Actually it was taking time because I had used both "where" clause and "group by" clause in the same table. This should run fine with no issue, but I assume it was not loading for me because of large data.

Solution :

I made an initial load of the table and used only the where condition in it. Then made a resident table of the main table for the calculations and used group by statement on the resident table.

Thanks,

Umar