topic Re: Set Analysis in QlikView

Set Analysis

hkg_qlik — Mon, 21 May 2012 18:00:41 GMT

Hi,

I am building a dashboard which requires an object to display value according to fixed constraints, so even if i make selection in the adjacent charts/filter objects it should not change its value on any selection made in the work sheet.

here is what i am using :

=count(distinct (if (Status = 'Active' or Status ='Waiting for Resolution'), [Counter Incident Number])))

Regards,

Re: Set Analysis

oscar_ortiz — Mon, 21 May 2012 18:06:22 GMT

I believe you're looking to do something like this.

count( {$< Status = {'Active','Waiting for Resolution'} >} DISTINCT [Counter Incident Number])

Good luck

Oscar

Set Analysis

kaushiknsolanki — Mon, 21 May 2012 18:07:33 GMT

Hi,

Use below expression

Count({1<Status = {"Active","Waiting for Resolution"}>}Distinct [Counter Incident Number])

Here 1 specifies that it will not listen to any of your selection.

Regards,

Kaushik Solanki

Set Analysis

swuehl — Mon, 21 May 2012 18:08:05 GMT

Try

=count({1<Status = {'Active','Waiting for Resolution'}>} distinct [Counter Incident Number])

Re: Set Analysis

hkg_qlik — Mon, 21 May 2012 18:54:18 GMT

Thank you all for your reply.

It's still changing the values. Do I have to change any document/user setting? the formula looks right to me.

I am using Gauge Chart.

I have tried it in QV 10 SR3 and SR4.

Regards,

Re: Set Analysis

IAMDV — Tue, 22 May 2012 09:02:47 GMT

That's unusual! Both Kaushik's and Stefan's solutions should work. Please can you post the QVW file?

Cheers,