Exclude If condition values from selected values

[vengadeshpalani]

Hi all,

By using if condition  "if(Status='C' and StatusDate< MonthEnd( StatusMonth),JobID)" it return some JobID but i need exculude this JobID from selected JobID

Example :

I selected A,B,C,D,E,F

if condition return C,D,E

so result should be A,B,F

[m_woolf]

maybe:

if(Status<>'C' or StatusDate>= MonthEnd( StatusMonth)),JobID)

[vengadeshpalani]

I can't change Expression

[jonathandienst]

>>I can't change Expression

So how would you  like to "exclude" the values? You need to be more detailed in your explanation, or upload a small sample that illustrates the issue.

Is this in a table or chart? is it in a text box, list box... and so on.

[vengadeshpalani]

pls find the attachment in my post

[m_woolf]

You select the values and then choose Select Excluded.

You can either do othis manually, or create a button with those actions.

[Anil_Babu_Samineni]

Still we are not following, When you click on Feb you want to count only for 11 - JobID? What does this mean

[malini_qlikview · Accepted solution]

Hi,

You could use advanced set analysis for this, try if the below helps,

Count( {$-1<JobID={"=Count(DISTINCT  if(Status='C' and StatusDate< MonthEnd( StatusMonth),JobID))"}>} JobID)

the output is the below,

Thanks.

[vengadeshpalani]

thank's Malini