Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Analyis Not Working: Only Include These Values

Hello all,

I work for a large company that closes deals on orders. Every time the order is closed and won, the job status switches to 'Closed - Won'. I'm trying to make a chart would would only include these values, but I'm having a hard time understanding why my set analysis isn't working.

Here's the expression I'm trying to use:

TextCount({$<JOBSTATUS={$(='Closed - Won')}>}JOBSTATUS)

If anyone can provide any help, that would be greatly appreciated!

1 Solution

Accepted Solutions

Re: Set Analyis Not Working: Only Include These Values

May be try this:

Count({$<JOBSTATUS={'Closed - Won'}>}JOBSTATUS)

2 Replies

Re: Set Analyis Not Working: Only Include These Values

May be try this:

Count({$<JOBSTATUS={'Closed - Won'}>}JOBSTATUS)

Not applicable

Re: Set Analyis Not Working: Only Include These Values

Wow, it worked! Thanks so much Sunny!

Community Browser