topic Re: Apply If..Then to All objects? in QlikView

Apply If..Then to All objects?

cbaqir — Mon, 18 Dec 2017 19:38:28 GMT

I am trying to automate the creation of an Agenda via Nprinting and in order to do that, I need to return any DEFECT_ID in which there is a match on the Decision Body and Associated Agenda Date.

For example, in the ticket below, it should be on the list because I am looking for ECG as the Decision Body and the Agenda Date of 1/8/2018.

What's the best way to create this logic so that ALL objects only show the relevant DEFECT_IDs?

In the attachment, two tables show the right logic but if I set NPrinting to Page on DEFECT_ID, it won't capture the correct ones.

All I can think of is a really long if statement:

=if(PRIMARY_DECISION_BODY='ECG' and PRIMARY_DECISION_AGENDA_DATE=date(Min({$<AGENDA_DATE={">$(=today())"},GOV_DECISION_BODY_SUB={'ECG'}>}AGENDA_DATE),'MM/DD/YYYY'),1,
if(SECONDARY_DECISION_BODY='ECG' and SECONDARY_DECISION_AGENDA_DATE=date(Min({$<AGENDA_DATE={">$(=today())"},GOV_DECISION_BODY_SUB={'ECG'}>}AGENDA_DATE),'MM/DD/YYYY'),1,
if(THIRD_DECISION_BODY='ECG' and THIRD_DECISION_AGENDA_DATE=date(Min({$<AGENDA_DATE={">$(=today())"},GOV_DECISION_BODY_SUB={'ECG'}>}AGENDA_DATE),'MM/DD/YYYY') ,1,
if(FOURTH_DECISION_BODY='ECG' and FOURTH_DECISION_AGENDA_DATE=date(Min({$<AGENDA_DATE={">$(=today())"},GOV_DECISION_BODY_SUB={'ECG'}>}AGENDA_DATE),'MM/DD/YYYY'),1,
if(FIFTH_DECISION_BODY='ECG' and FIFTH_DECISION_AGENDA_DATE=date(Min({$<AGENDA_DATE={">$(=today())"},GOV_DECISION_BODY_SUB={'ECG'}>}AGENDA_DATE),'MM/DD/YYYY') ,1,
if(SIXTH_DECISION_BODY='ECG' and SIXTH_DECISION_AGENDA_DATE=date(Min({$<AGENDA_DATE={">$(=today())"},GOV_DECISION_BODY_SUB={'ECG'}>}AGENDA_DATE),'MM/DD/YYYY')
,1,0))))))

It should return only 6 tickets. As you can see in the Business Case chart, many more are being displayed and the DEFECT_ID list box doesn't show the right defects.

TIA

Re: Alternative of long if..then statement

Anil_Babu_Samineni — Tue, 19 Dec 2017 13:24:12 GMT

Is there any thing need still? Or you already got something? And your thread context from QlikView and your settings using N printing. Not sure, I followed you or not

Re: Alternative of long if..then statement

cbaqir — Tue, 19 Dec 2017 15:09:30 GMT

The issue is not resolved. The chart below still shows many defects that should not be showing:

This is ultimately a QV issue because the charts will be pulled into NPrinting. Nprinting creates a new tab or page for each set field - like DEFECT_ID. Therefore, I need the selected/associated Defects to be limited to the 6 above.

Re: Apply If..Then to All objects?

cbaqir — Tue, 19 Dec 2017 17:15:11 GMT

Maybe I can ask another way... is there a way I can create a variable perhaps to only show me the relevant DEFECT_IDs?

Ultimately I need selection criteria to filter out the DEFECT_ID field.

Re: Apply If..Then to All objects?

cbaqir — Tue, 19 Dec 2017 17:26:24 GMT

Trying to delete this post to move to an Nprinting thread but I don't have the rights.