topic Re: set analysis ignore selection in QlikView

set analysis ignore selection

florianrathgebe — Fri, 04 May 2018 07:09:40 GMT

Dear all,

I have got a Problem with set Analysis getting a selection Ignored.

Count(
// Closed Date nicht gesetzt
{$<KEY_EVENT_ID={"=Nullcount(INV_INVESTIGATION_CLOSE_DATE)=0"},
//KEY_EVENT_ID={"=Nullcount(EV_REJECTED_BY_RESPONSIBLE_DATE_FIRST)>0"},
EV_EVENT_SITE_DESC ={'Frankfurt FRI2SERV'},
//Aufhebung der Einschränkung von POST...
CLOSE_JAHR =,CLÖSE_JAHR_MONAT=,
//Einschränkung auf Event Type
EV_EVENT_TYPE ={'Deviation'},
//Einschränkung auf Beobachtung
EV_EVENT_CURRENT_STATUS -={'Closed with no further investigation*', 'Closed without investigation*'},
// Wurde nicht von Experten abgelehnt
EV_REJECTED_BY_RESPONSIBLE_DATE_COUNT={0},
EV_REJECTED_BY_EXPERT_DATE_COUNT={0}

>}DISTINCT KEY_EVENT_ID)

This Statement does not Ignore the Close_Jahr and Close_JAHR_Monat.

But when I remove the part "KEY_EVENT_ID={"=Nullcount(INV_INVESTIGATION_CLOSE_DATE)=0"}," the selection is ignored. The Problem ist that I Need this part to get the result true result.

The Close_jahr und Close_jahr_Monat will be selected by Users.

If there are any questions don't hesitate to coantct me

Hope someone can help me.

Best regards,

Florian

Re: set analysis ignore selection

sunny_talwar — Fri, 04 May 2018 15:42:39 GMT

Try this

Count(
// Closed Date nicht gesetzt
{$<KEY_EVENT_ID={"=NullCount({<CLOSE_JAHR , CLÖSE_JAHR_MONAT>} INV_INVESTIGATION_CLOSE_DATE)=0"},
//KEY_EVENT_ID={"=Nullcount(EV_REJECTED_BY_RESPONSIBLE_DATE_FIRST)>0"},
EV_EVENT_SITE_DESC ={'Frankfurt FRI2SERV'},
//Aufhebung der Einschränkung von POST...
CLOSE_JAHR =,CLÖSE_JAHR_MONAT=,
//Einschränkung auf Event Type
EV_EVENT_TYPE ={'Deviation'},
//Einschränkung auf Beobachtung
EV_EVENT_CURRENT_STATUS -={'Closed with no further investigation*', 'Closed without investigation*'},
// Wurde nicht von Experten abgelehnt
EV_REJECTED_BY_RESPONSIBLE_DATE_COUNT={0},
EV_REJECTED_BY_EXPERT_DATE_COUNT={0}

>}DISTINCT KEY_EVENT_ID)

Re: set analysis ignore selection

florianrathgebe — Fri, 04 May 2018 18:48:42 GMT

Hi Sunny, I'm sorry the result is the same, it doesn't work.

Best regards,

Florian

Re: set analysis ignore selection

sunny_talwar — Fri, 04 May 2018 19:39:23 GMT

Would it be possible to share a sample to show the problem?

Re: set analysis ignore selection

florianrathgebe — Mon, 07 May 2018 05:44:22 GMT

Hi Sunny,

I'm sorry it doesn't work. My example is to set the "POST_JAHR_MONAT" on March 2018. In this case there are 13 "Deviations Geschlossen". When I now set "CLOSE_JAHR_MONAT" any value, it should not chnage the value in "Deviations Geschlossen", but it does. Even the example you have showed me in the screenshot, I can't verify it, have you attached the correct file?

Best regards,

Florian

Re: set analysis ignore selection

sunny_talwar — Mon, 07 May 2018 11:20:53 GMT

Check this

Expression

Count(

// Closed Date nicht gesetzt

{$<KEY_EVENT_ID={"=NullCount({<CLOSE_JAHR , CLOSE_JAHR_MONAT>} INV_INVESTIGATION_CLOSE_DATE)=0"},

//KEY_EVENT_ID={"=Nullcount(EV_REJECTED_BY_RESPONSIBLE_DATE_FIRST)>0"},

EV_EVENT_SITE_DESC ={'Frankfurt FRI2SERV'},

//Aufhebung der Einschränkung von POST...

CLOSE_JAHR =,CLOSE_JAHR_MONAT=,

//Einschränkung auf Event Type

EV_EVENT_TYPE ={'Deviation'},

//Einschränkung auf Beobachtung

EV_EVENT_CURRENT_STATUS -={'Closed with no further investigation*', 'Closed without investigation*'},

// Wurde nicht von Experten abgelehnt

EV_REJECTED_BY_RESPONSIBLE_DATE_COUNT={0},

EV_REJECTED_BY_EXPERT_DATE_COUNT={0}

>}DISTINCT KEY_EVENT_ID)

Make sure that CLOSE is spelled with O and not Ö...

Re: set analysis ignore selection

florianrathgebe — Mon, 07 May 2018 18:35:08 GMT

Dear Sunny, Thank you for your support.

Could you please be so kind to delete the attached file. I have seen that there are some sensible data which should not be published.

Best regards,

Florian

Re: set analysis ignore selection

sunny_talwar — Mon, 07 May 2018 18:41:20 GMT

Done, expression can stay, right?

Re: set analysis ignore selection

florianrathgebe — Wed, 09 May 2018 14:17:25 GMT

Thank you, yes the expression can stay.