Transform a set expression to an expression in the script

Yes, but I have found yet another problem in my first expression;

Let me do a recap:

As I already said in the first msg above; I have to count (dossier) for each date_embarquement/plaque only in one carrier :

count({<Code_Ligne={'MAR'}

,Groupe_Complet_Vide={c,C,G}

,Dossier = {"=Count(Aggr((Code_Carrier&Plaque),Date_Embarquement,Plaque))=1"}>} Dossier)

Now, the problem is that I work with variables to do time based analytics (yearly, monthly etc)

To do so, I have to select a Year, a timeframe and so on :

It all works fine in the present period, BUT in the PREVIOUS one; it does not and I know why:

Here is the situation:

My expression for the previous period :

count({<$(vSetPeriodPrev),Code_Ligne={'MAR'}

,Groupe_Complet_Vide={c,C,G}

,Dossier = {"=Count(Aggr((Code_Carrier&Plaque),Date_Embarquement,Plaque))=1"}>} Dossier)

Let's assume we selected yearly: the vSetPeriodPrev variable will call the YearlyPrev Variable which is like this:

[Calendar date]=,[Year of date]=,[Month of date]=,

[Year of date]={"$(=max([Year of date])-$1)"}

Now, the problem is : In my expression, for the previous period; when I select year of date=2017,

I want my expression to count code_carrier&plaque by date_embarquement in the year 2016 (which is the previous year) !

BUT, when I select 2017 : with the Qlik Associativity, ONLY the date_embarquement in the year 2017 will still be seen and thus; I can not perform this part of the expression:

Dossier = {"=Count(Aggr((Code_Carrier&Plaque),Date_Embarquement,Plaque))=1"}

Now, if I select 2017 AND 2016 (it will take the max and work with it BUT the date_embarquement of the year 2016 will be available, so my expression will return the right value:

My question is, what do I have to change?

What should I do to force the 'association of qlik ' not to work?

To force the date_embarquement in 2016 to be available even if I select year of date 2017?

Hope that was rather clear..

See: when I choose 2016, the prev expression (with group)={c,C,G} :

Now, when I choose 2015, the pres expression should be 580; but it's 585 :

As I said, this problem occurs when in my expressions I work with :

Groupe_Complet_Vide={c,C,G}

When I work with Groupe_Complet_Vide={V}, I don't have this problem

ps: I already changed my script as follow:

Maroc:

LOAD

"%Date ID",

    Code_Activite,

    Designation_Activite,

Date_Embarquement,

    Plaque,

....

    Remorque_Parc_HorsParc,

    Voyage_Ligne,

  Pays,

    PAYS2,

    Charge_Vide

FROM [lib://qvd/final_16-03-017.qvd]

(qvd)

Where Code_Ligne = 'MAR' 

;

Left Join(Maroc)

LOAD

    Date_Embarquement,

    Plaque,

  Only(Code_Carrier) as code

FROM [lib://qvd/final_16-03-017.qvd]

(qvd)

Where Code_Ligne = 'MAR' 

Group by Date_Embarquement,Plaque

;

Concatenate

NoMaroc:

LOAD

"%Date ID",

    Code_Activite,

    Designation_Activite,

    Sens,

    Filiale_Creation_Dossier,

...

    Remorque_Parc_HorsParc,

    Voyage_Ligne,

  Pays,

    PAYS2,

    Charge_Vide

FROM [lib://qvd/final_16-03-017.qvd]

(qvd)

Where Code_Ligne <> 'MAR' 

;

And my expression is now becoming really simple : count({<$(vSetPeriodPrev),Code_Carrier={'MAR'}>}Dossier)

But, I'm just curious to know why is there a problem with the Groupe_Complet_Vide={c,C,G}

You can see it since you ahev the app in hand

Hope that was rather clear?