Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

darrin_pilkingt
Contributor II

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

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.

1 Solution

Accepted Solutions
Not applicable

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

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.

2 Replies
Not applicable

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

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.

darrin_pilkingt
Contributor II

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

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.

Community Browser