Getting started filtering records

[#1]

Hi,

I'm a complete beginner with Qlikview, and have finished the sample tutorial based on Northwind.

I have now started to put it together with my own data and am struggling to understand the selection concept.

I have a table that contains a number of documents that are sent to a third party for printing. In this table there is a column called 'PrintReason'. I would like to exclude one of my PrintReasons from the select fields on Tab1 of my work sheet, but I would like it available to other times I use the same field on a different tab so I can't exclude that using a 'Where <>' type expression in my LOAD/Select statement.

How can I have this one PrintReason not appear in the fields on tab 1, but have it appear in a field on tab 2?

I hope this makes sense, I'm just starting to feel my way around the product so I'm not 100% sure of the terminology used.

Many thanks,

Andy.

[vivientexier]

Hi Andy,

Easy, just create 2 Fields. One full and one without some value.

LOAD

       *

     , PrintReason as PrintReason_full

     , If(PrintReason <> 'Blablablabla', PrintReason) as PrintReason_small

FROM ...

[Gysbert_Wassenaar]

If you're using QV11 you can use alternate states. See here for a tutorial. The tutorial deals with a case that's probably a bit more complicated than yours, but the principles are the same. You want to use the same field with different states for different objects.