topic Exclude data based on selection in QlikView

Exclude data based on selection

Sunil_Kenth — Fri, 10 Jun 2011 12:45:11 GMT

Hi All,

I have a data set which has some 'dirty' data in. I would like to exclude this dirty data when a selection is made.

This is what I have:

A selection box called 'Status', with the following values:

Active

Cancelled

Completed

On Hold

A table box containing the following columns:

Name

Start Date

Finish Date

Status

% Complete

What i would like to do is exclude entries in the table box that have a value of 100% in the '%Complete' column when the 'Active' status is selected.

I figure i need some sort of set analysis to do this but not sure what the syntax is and where i would place this syntax.

Thanks in advance for your help.

Sunil

Exclude data based on selection

Fri, 10 Jun 2011 15:33:31 GMT

You might be better off getting rid of those in the script or just make a flag for them.

Something like....

if([% Complete]=1 and Status='Active',1,0) as 'Exclusion Flag'

Then you just always have 0 selected if you really wanted to load them. If you have other things you want to exclude, you could just add them in there as well.

Re: Exclude data based on selection

IAMDV — Fri, 10 Jun 2011 20:51:44 GMT

Sunil - Yes, you might need set analysis. Please can you post an sample QV document and also can you explain in more detail with text boxes. It will help us to solve the issue ASAP.

Cheers - DV

Exclude data based on selection

Sunil_Kenth — Tue, 14 Jun 2011 12:30:49 GMT

Thanks Trent that works a treat.

DV - many thanks for you response too.

Sunil