topic Set Analyis Not Working: Only Include These Values in QlikView

Set Analyis Not Working: Only Include These Values

Tue, 24 May 2016 14:21:49 GMT

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!

Re: Set Analyis Not Working: Only Include These Values

sunny_talwar — Tue, 24 May 2016 14:33:03 GMT

May be try this:

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

Re: Set Analyis Not Working: Only Include These Values

Tue, 24 May 2016 20:40:12 GMT

Wow, it worked! Thanks so much Sunny!