Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
vengadeshpalani
Contributor

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

Tags (2)
1 Solution

Accepted Solutions
malini_qlikview
Contributor II

Re: Exclude If condition values from selected values

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.

8 Replies
mwoolf
Honored Contributor II

Re: Exclude If condition values from selected values

maybe:

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

vengadeshpalani
Contributor

Re: Exclude If condition values from selected values

I can't change Expression

MVP
MVP

Re: Exclude If condition values from selected values

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

Re: Exclude If condition values from selected values

Screenshot_10.png

pls find the attachment in my post

mwoolf
Honored Contributor II

Re: Exclude If condition values from selected values

You select the values and then choose Select Excluded.

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

Re: Exclude If condition values from selected values

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

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
malini_qlikview
Contributor II

Re: Exclude If condition values from selected values

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
Contributor

Re: Exclude If condition values from selected values

thank's Malini