Trying to exclude all values in set analysis but one list box

[Anonymous]

I have a dashboard that I have as an overview of all records for yesterday and the last seven days with the Identifier = 1 to disregard all selections.

What I need is to disregard all selection except one.  Dept

Is there something I can add to the formula below to pull in the list box for Dept only?

Formula for example:

count( {1 <DaySerial = {'$(vYesterday)'}>} JournalID)

Thanks for the help.

[#2 · Accepted solution]

Hello Darrin,

You can add the below to your set analysis, to take into consideration the possible values in the dept field:

Dept = P(Dept)

Also check out this document for other interesting alternatives:

http://community.qlik.com/docs/DOC-1334

Hope this helps.

[Anonymous]

JP, thank you very much and that worked perfecty.  I was aware of the P() possible values but hadn't seen it in action to realize it's usage.

Thanks again.