5 Replies Latest reply: May 22, 2012 5:02 AM by Deepak Vadithala RSS

Set Analysis

hkgandhi

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

  • Re: Set Analysis
    Oscar Ortiz

    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
    Kaushik Solanki

    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

    Try

     

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

  • Re: Set Analysis
    hkgandhi

    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.