topic Adding new row in a table in QlikView

Adding new row in a table

Tue, 02 Apr 2013 00:12:41 GMT

hi All,

I am attaching this document which explain my situation. I have Category with A,B and C values. and when i Pick A , i see A1,A2 and A3 as SubCategories in Sucategory field.

I want A in Category to only show A1,A2 in Subcategory. and have new value in Category as A_Excluding_A1 and when i select that i only get A1 in Subcategory.

Please see attached screenshot. I want this to be done in script.

Re: Adding new row in a table

somenathroy — Tue, 02 Apr 2013 03:21:32 GMT

Hi,

Try with the below code:

LOAD *

FROM

[MyTable.qvd]

(qvd)

Where not Match(SubCategory,'Toothpaste');

Concatenate

LOAD DivisionKey,

Division,

SubsidiaryKey,

Subsidiary,

CategoryKey,

Category & ' ' & SubCategory as Category,

SubCategoryKey,

SubCategory,

CalKey,

CalYear,

Month,

Year,

[Inventory Value],

[GROSS PROFIT MARGIN],

[NET SALES],

COSG,

counter,

AvgCOSG

FROM

[MyTable.qvd]

(qvd)

Where Match(SubCategory,'Toothpaste');

Regards,

Som

Re: Adding new row in a table

Thu, 04 Apr 2013 23:10:37 GMT

Thank you Som