topic Re: Exclude If condition values from selected values in QlikView

Exclude If condition values from selected values

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Exclude If condition values from selected values

m_woolf — Tue, 11 Apr 2017 12:08:57 GMT

maybe:

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

Re: Exclude If condition values from selected values

vengadeshpalani — Tue, 11 Apr 2017 12:18:22 GMT

I can't change Expression

Re: Exclude If condition values from selected values

jonathandienst — Tue, 11 Apr 2017 12:27:52 GMT

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

Re: Exclude If condition values from selected values

vengadeshpalani — Tue, 11 Apr 2017 12:44:43 GMT

pls find the attachment in my post

Re: Exclude If condition values from selected values

m_woolf — Tue, 11 Apr 2017 13:37:43 GMT

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

Anil_Babu_Samineni — Tue, 11 Apr 2017 13:39:54 GMT

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

Re: Exclude If condition values from selected values

malini_qlikview — Tue, 11 Apr 2017 13:55:12 GMT

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.

Re: Exclude If condition values from selected values

vengadeshpalani — Tue, 11 Apr 2017 14:12:14 GMT

thank's Malini