Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
florianrathgebe
Contributor II
Contributor II

set analysis ignore selection

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

1 Solution

Accepted Solutions
sunny_talwar

Check this

Capture.PNG

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

View solution in original post

8 Replies
sunny_talwar

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)

florianrathgebe
Contributor II
Contributor II
Author

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

Best regards,

Florian

sunny_talwar

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

florianrathgebe
Contributor II
Contributor II
Author

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

sunny_talwar

Check this

Capture.PNG

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

florianrathgebe
Contributor II
Contributor II
Author

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

sunny_talwar

Done, expression can stay, right?

florianrathgebe
Contributor II
Contributor II
Author

Thank you, yes the expression can stay.