Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

selecting un-selected records?

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!

8 Replies
Not applicable

Re: selecting un-selected records?

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

Regads,

Ricardo

Re: selecting un-selected records?

You can use a set analysis expression. Something like:

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


talk is cheap, supply exceeds demand
Not applicable

Re: selecting un-selected records?

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.

Not applicable

Re: selecting un-selected records?

Shared.

Re: selecting un-selected records?

See attached example


talk is cheap, supply exceeds demand
Not applicable

Re: selecting un-selected records?

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?

Not applicable

Re: selecting un-selected records?

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?

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.


talk is cheap, supply exceeds demand
Community Browser