Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted
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.

View solution in original post

2 Replies
Highlighted
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.

View solution in original post

Highlighted
Creator II
Creator 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.