Discussion Board for collaboration on QlikView Scripting.
I want to exclude certain values in a table.
For eg , In the Category table below , I want to excluded PRICE , LOA & REPORT GROUP . How do I do the scripting ?
If you want to do this on the Script, you could use the inner join:
// To keep only Category
// TV & VIDEO
inner Join ( FullTab )SelectedValues:LOAD * INLINE [CategoryTV & VIDEO TORCHES ]
Hope I Could Help
Try like this
Load If(not wildmatch(Category, 'PRICE' , 'LOA','REPORT GROUP'), Category) as Category from tablename;
Hope that helps
thanks. Will try and let you know.
It's just the same as Mayil suggested but in the case you want to load more fields than Category from the same table, you should move that condition to the WHERE clause:
WHERE NOT MATCH (Category, 'PRICE' , 'LOA','REPORT GROUP')
You can do that like this:
Thanks for all the responses. The actual model i have a a bit more complicated. I'll try the formulae given and give feedback.
The formula dont seem to work. What I have done is created an extract of my database in excel.
Below are 5 items with main category and sub category (I've also attached an excel file)
Also attached is a list of main Categories and Sub-Categories.
In the table below i dont want to lines if the Main Category Code = PRICE, REPORTGRP or LOA . How do i do the scripting. For each item there should be only one line.
Just to let you know, on our database for Main Category Code equal to:
Your help would be appreciated.
The formula dont seem to work. What i have done is create an extract of my database in excel.
In the table below i dont want to lines if the Main Category Code = PRICE, REPORTGRP or LOA . For each item there should be only one line.