topic Ignore fields from a Dimension? in QlikView

Ignore fields from a Dimension?

Tue, 14 Jun 2011 07:58:30 GMT

Hello I have a dimension called dahboarfieldname which I am getting from a standard Monthly.QVS(Script). My question is I have some fields within the dashboardfilename table from which I want to drop the fields like Trading Income, Legal Docs, Clearing. Whats the best way to do this as I cannot import the full tables and then comment these fields out? Also can this be achieved with Set Analysis on a Pivot?

Thanks in advance

Mady

Ignore fields from a Dimension?

Tue, 14 Jun 2011 08:06:19 GMT

Adding to the above question I have the connection like this. And from here comes the table Dashboard, in which I have a field Dashboardfilename in there are all these fields as mentioned above...

CONNECT TO $(StrConnMonthly);

$(Include=scriptfiles\data_monthly.qvs)

hope this helps, thanks again

Mady

Re: Ignore fields from a Dimension?

Tue, 14 Jun 2011 08:29:34 GMT

Hi,
This may be one way to do this...

Monthly_TMP:

CONNECT TO $(StrConnMonthly);

$(Include=scriptfiles\data_monthly.qvs)

Monthly:

LOAD *

RESIDENT Monthly_TMP;

Drop Fields [Trading Income], [Legal Docs], Clearing;

Drop Table Monthly_TMP;

/@Ungvall

Ignore fields from a Dimension?

Tue, 14 Jun 2011 08:54:06 GMT

Hello Thankyou for the quick reply, but i have an error as Table not found Monthly and moreover I was wondering if this looks into the Dashboard Table, Dashboardnamefield Field and the data within there Trading Income..??

Just wondering why is it that hard to do it in QV or if i am unable to get to it??

Anymore help please?

Thanks in advance