topic Re: Drop Field in QlikView

Drop Field

gauthamchilled — Wed, 24 Feb 2016 07:36:34 GMT

I ran the Doc analyzer as per the idea to get the list of fields which are unused.

I added the drop fields statement in my dashboard at the end. But after reloading the dashboard, once the script execution is over

the dashboard hangs.

But if i remove the drop statement of unused fields, the dashboard not hang.

how can i fix this?

file size is 150MB, RAM is 6GB. this happens in empty sheet with no objects.

Re: Drop Field

Anonymous — Wed, 24 Feb 2016 07:40:35 GMT

may be something wrong in syntax?

You can drop fields like this?

Load

//A, By Commenting

//B,

From Table;

drop fields A,B;

drop field A;

Hope this will help!!

Re: Drop Field

Chanty4u — Wed, 24 Feb 2016 07:41:53 GMT

based on ur num of chrts

and num set expressions in frnt end...

if is there any macros.

highly coulr coding..

may hangs ur app.

Re: Drop Field

Chanty4u — Wed, 24 Feb 2016 07:56:49 GMT

did u restrt ur machine and reload again?

May be

Re: Drop Field

gauthamchilled — Wed, 24 Feb 2016 08:00:52 GMT

rwunderlich‌

Do you have any idea?

Re: Drop Field

Anonymous — Wed, 24 Feb 2016 08:01:51 GMT

Could you share your script?

Re: Drop Field

jagan — Wed, 24 Feb 2016 08:07:53 GMT

Hi Gautham,

I think the dropped field is using somewhere in the charts that is why you are getting this issue. Check carefully.

Regards,

Jagan.

Re: Drop Field

Siva_Sankar — Thu, 25 Feb 2016 04:28:34 GMT

Gautham,

Check the drop field that you copied from doc analyzer have some key columns(escpecially composite key columns).

Try commenting those columns and run the app. Check if you see the issue is gone.

You can narrow down the issue in this way.

If they keys causes the issue, then try autonumber function on creating those composite keys and then use it in drop field statement.

Re: Drop Field

Anonymous — Thu, 25 Feb 2016 04:32:47 GMT

may be connections problem or expressions wrong

Re: Drop Field

gauthamchilled — Thu, 25 Feb 2016 05:35:57 GMT

Thanks Shankarece.. The composite key columns were the issue. Resolved now.

Gautham