Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
Thanks Trent that works a treat.
DV - many thanks for you response too.
Sunil