Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding new row in a table

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.

.

1 Solution

Accepted Solutions
somenathroy
Creator III
Creator III

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

View solution in original post

2 Replies
somenathroy
Creator III
Creator III

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

Not applicable
Author

Thank you Som