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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting started filtering records

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.

2 Replies
vivientexier
Partner - Creator II
Partner - Creator II

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
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand