topic Re: selecting un-selected records? in QlikView

selecting un-selected records?

Tue, 19 Mar 2013 15:16:31 GMT

Hey guys. Need your help.

I'm creating a QV chart to show all consultants that have submitted time sheets for a given week.

I have a table box (called "submitted") that has a list of consultant names. I then have a list box, which allows you to select a particular week-ending date. This will (obviously) filter the consultant names in the "submitted" table by consultants that have submitted a timesheet for that particular week-ending date.

Is there a way to create another table, which shows which consultants did NOT submit a timesheet for the week-ending date that was selected? In other words, a table that shows which consultants dropped off the "submitted" table, when I selected the week-ending date?

Thanks!

Re: selecting un-selected records?

Tue, 19 Mar 2013 15:29:09 GMT

This is possible, but is better if you share your app.

Regads,

Ricardo

Re: selecting un-selected records?

Gysbert_Wassenaar — Tue, 19 Mar 2013 15:29:39 GMT

You can use a set analysis expression. Something like:

count({<ConsultantName=e({<WeekEndingDate={$(=only(WeekEndingDate))}>} ConsultantName )>} 1)

Re: selecting un-selected records?

Tue, 19 Mar 2013 15:36:40 GMT

Gysbert, wouldn't that just give me a count, not the actual consultant names?

I've attached my QV. Since I'm terrible at explaining (guilty!) - you can see the "Submitted" table, and on the left, the "Week-Ending" list box. I need an additional table, which shows me the consultant names which fall off the "Submitted" table when you select a Week-Ending date.

Re: selecting un-selected records?

Tue, 19 Mar 2013 16:42:39 GMT

Shared.

Re: selecting un-selected records?

Gysbert_Wassenaar — Wed, 20 Mar 2013 17:32:07 GMT

See attached example

Re: selecting un-selected records?

Thu, 21 Mar 2013 13:20:10 GMT

Thank you, Gysbert! Can you explain the expression you wrote? I've never seen it used before.

Also, would there be a way to filter this so it only shows consultants that have a "Practice Name" tied to them?

Re: selecting un-selected records?

Thu, 21 Mar 2013 13:57:06 GMT

basically, I need it to filter the way you have it now, but I need it to still filter as the user selects a Practice, Consultant Status, etc.

Re: selecting un-selected records?

Gysbert_Wassenaar — Thu, 21 Mar 2013 17:08:11 GMT

Could you create an excel file with some lists that show who should be in which listed based on some selections? I don't know what the correct results should be. Having some examples to match with would help.