Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
vengadeshpalani
Creator
Creator

Exclude If condition values from selected values

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

1 Solution

Accepted Solutions
malini_qlikview
Creator II
Creator II

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,

Set.png

Thanks.

View solution in original post

8 Replies
m_woolf
Master II
Master II

maybe:

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

vengadeshpalani
Creator
Creator
Author

I can't change Expression

jonathandienst
Partner - Champion III
Partner - Champion III

>>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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vengadeshpalani
Creator
Creator
Author

Screenshot_10.png

pls find the attachment in my post

m_woolf
Master II
Master II

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

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
malini_qlikview
Creator II
Creator II

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,

Set.png

Thanks.

vengadeshpalani
Creator
Creator
Author

thank's Malini