Script Execution Is Not Fetching Data

[umartareen]

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

[tamilarasu]

Could you post your script.?

[marcus_sommer]

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

[HirisH_V7]

Hi,

Can you provide your sample script?!

-Hirish

[umartareen]

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