Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

sspringer
New Contributor

Match Null Values

I have 2 tables:

1) Data - Transaction level detail with various rows of charges - some rows have product ID's with associated unit charges, other rows have no product ID, only an amount for tax

2) Categories - This table links to the data table to provide a category for each product ID sold.

How do I reference the "Categories" and whenever the row contains a nullvalue for product ID or unit charge, have it categorize that charge as "Taxes"?

Thank you

Scott

2 Replies
sspringer
New Contributor

Re: Match Null Values

Thank you for the quick responses guys!  Hmmmmm, I can't get either of these to work, let me pose another problem I am having with my data that is very similar, it may help:  Table 1-LineItem Detail, Table2-Contract Category.  The 2 tables link from a SKU field where Table2 will look up the SKU from Table1 and return either - CORE or CATALOG.  I want to be able to use a list box with selections of: CORE/CATALOG/NON-CORE, where NON-CORE is everything where the SKU in Table 1 is not found in Table2.  Any ideas!?  Thank you!

MVP
MVP

Match Null Values

If you just want to lookup a value from table 1 in table 2 and get another value back -  Core or Catalog, you could use a mapping load of table 2 and use applymap() function in table 1 with a default value of  'NON-CORE'. Please refer to the manual for all details.

Regards,

Stefan

Community Browser