Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.