topic Set analysis in QlikView

Set analysis

MauriceLudo — Fri, 10 Feb 2017 14:58:48 GMT

Hello,
I would like to know how to translate this rule of management into set analysis: we try to calculate the number of Pdc processed per month
Pdc created the selected month (N°ligne PDC)
Status terminated or canceled (Status)
Different closing date and month of creation (Mois_création, Mois_Cloture)

=count({< Mois_Création= {'$(=$(vMois_Creation))'}>+<[Statut Prise de contact]={Terminée,Annulée} , Mois_Cloture<>Mois_Creation))'} >} N°Ligne_PDC)

Thank you

Best regards

Re: Set analysis

vinieme12 — Fri, 10 Feb 2017 15:32:44 GMT

Try below, or post a sample app, it's easier that way Preparing examples for Upload - Reduction and Data Scrambling

=count({< Mois_Création= {'$(=$(vMois_Creation))'} , [Statut Prise de contact]={'Terminée','Annulée'} , Mois_Cloture = {" = Mois_Cloture <> Mois_Creation"} >} N°Ligne_PDC)

Re: Set analysis

vishsaggi — Fri, 10 Feb 2017 15:33:03 GMT

What are the date formats for these two fields ?

Mois_Cloture , Mois_Creation

=count({< Mois_Création= {"= $(= $(vMois_Creation))"} , [Statut Prise de contact] ={ 'Terminée', 'Annulée' } , Mois_Cloture = { "<> Mois_Creation" } >} N°Ligne_PDC)

Try this ?

Re: Set analysis

vishsaggi — Fri, 10 Feb 2017 15:35:27 GMT

HI Vineeth,

Why do we have these two brackets? They should not be there or is that i am not seeing something?

=count({< Mois_Création= {'$(=$(vMois_Creation))'} , [Statut Prise de contact]={'Terminée','Annulée'} , Mois_Cloture = {" = Mois_Cloture <> Mois_Creation"))'} >} N°Ligne_PDC)

Re: Set analysis

vinieme12 — Fri, 10 Feb 2017 15:38:22 GMT

typo

Re: Set analysis

vishsaggi — Fri, 10 Feb 2017 15:45:18 GMT

OK cool. 🙂

Re: Set analysis

MauriceLudo — Fri, 10 Feb 2017 16:12:50 GMT

Format Date ( janv. févr. , mars)

Re: Set analysis

vishsaggi — Fri, 10 Feb 2017 16:20:51 GMT

OK did you try Vineeth's or My expressions? If it doesnt you have to give us more information and expected output you are looking for?

Re: Set analysis

MauriceLudo — Mon, 13 Feb 2017 11:01:51 GMT

Hello,
My request is next:
Each request to:    - a date of creation
                              - a date of treatment
                              - a status: processed, completed, canceled, in progress
I take the example of July
A request can be:        - create and process in July
                                    - not created in July processed in July
                                    - created and not processed in July

I am trying to calculate - the number of applications created in July
                              - the number of applications processed in July
                              - the number of applications created and not processed in July
                              - the number processed and not created in July

The number of requests created in july : create in july and close in july ( or closed without date )

=count({< [Statut Prise de contact] ={ 'Terminée', 'Annulée' } , Mois_Cloture = { "<> Mois_Creation" } >} N°Ligne_PDC)

Attached the July and Juin file