Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I believe you're looking to do something like this.
count( {$< Status = {'Active','Waiting for Resolution'} >} DISTINCT [Counter Incident Number])
Good luck
Oscar
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
Try
=count({1<Status = {'Active','Waiting for Resolution'}>} distinct [Counter Incident Number])
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.
H,
That's unusual! Both Kaushik's and Stefan's solutions should work. Please can you post the QVW file?
Cheers,
DV