Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Master II
Master II

maybe:

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

Highlighted
Creator
Creator

I can't change Expression

Highlighted

>>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
Highlighted
Creator
Creator

Screenshot_10.png

pls find the attachment in my post

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

Highlighted

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)
Highlighted
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

Highlighted
Creator
Creator

thank's Malini