topic Re: Help with exists function for more than one variable? in QlikView

Help with exists function for more than one variable?

Wed, 25 Nov 2020 16:16:04 GMT

I need to exclude employees with no related sales from loading into my dashboard using the exists function. Employees show up in more than table that I'm loading. Can anyone help with this?

Re: Help with exists function for more than one variable?

sunny_talwar — Mon, 03 Oct 2016 20:58:36 GMT

What is the script you have today?

Re: Help with exists function for more than one variable?

Mon, 03 Oct 2016 21:32:36 GMT

Thank you so much for your offer to help. I found the answer was to use "Inner Keep," making sure that the first table with employee data was immediately before the second table in the script.

Re: Help with exists function for more than one variable?

rulohx87 — Mon, 03 Oct 2016 23:22:37 GMT

Close Topic or Choose the answer correct.

Re: Help with exists function for more than one variable?

Tue, 04 Oct 2016 00:48:58 GMT

Correct.

Re: Help with exists function for more than one variable?

Anonymous — Tue, 04 Oct 2016 15:15:33 GMT

Hi Laura,

In order to close the thread, I've chosen your reply and clicked the Correct Answer button. In the future, you can use this option to close your threads once they have been resolved. To find the Correct Answer button, you'll have to view the thread in the community, since it does not appear in email notifications or in your profile's Activity list.

For more information, check out the Community Tip: Marking Replies as Correct or Helpful, or let me know if you have any further questions.

Best regards,

Qlik Community Team

Re: Help with exists function for more than one variable?

Tue, 04 Oct 2016 17:46:23 GMT

Thank you so much! I am new to Qlikview and appreciate the tips.

Best,Laura

Happy Connecting. Sent from my Sprint Samsung Galaxy S® 5