topic Getting started filtering records in QlikView

Getting started filtering records

Mon, 11 Feb 2013 16:16:37 GMT

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.

Re: Getting started filtering records

vivientexier — Mon, 11 Feb 2013 16:25:50 GMT

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 ...

Re: Getting started filtering records

Gysbert_Wassenaar — Mon, 11 Feb 2013 16:40:08 GMT

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.