Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

Set Analysis

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,

H

5 Replies
oscar_ortiz
Partner - Specialist
Partner - Specialist

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

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

Good luck

Oscar

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
swuehl
MVP
MVP

Try

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

hkg_qlik
Creator III
Creator III
Author

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,

H.

IAMDV
Luminary Alumni
Luminary Alumni

H,

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

Cheers,

DV