cancel
Showing results for
Did you mean:
Contributor II

## Set analysis : 2 champs égaux

je suis nouveau sur la forum,

Avez-vous Une idée de mon erreur?

Somme ({<

[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= (max ([SALES_INVOICES.YEAR])))},

NUM_MOVEMNT_DATE = NUM_JOUR_OUVRABLE,

[STR_S_PREVISIONS_VENTES.PERIOD] = {\$ (= Max ({<[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= Max ([SALES_INVOICES.YEAR]))}>} [SALES_INVOICES.PERIOD]))}

>} PREV_HECTO_QUANTITY)

Labels (1)
• ### Set

1 Solution

Accepted Solutions
try below

Somme ({<
[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= (max ([SALES_INVOICES.YEAR])))},
NUM_MOVEMNT_DATE = {"=NUM_MOVEMNT_DATE=NUM_JOUR_OUVRABLE"},
[STR_S_PREVISIONS_VENTES.PERIOD] = {\$ (= Max ({<[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= Max ([SALES_INVOICES.YEAR]))}>} [SALES_INVOICES.PERIOD]))}
>} PREV_HECTO_QUANTITY)

or
if( NUM_MOVEMNT_DATE=NUM_JOUR_OUVRABLE,
Somme ({<
[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= (max ([SALES_INVOICES.YEAR])))},
[STR_S_PREVISIONS_VENTES.PERIOD] = {\$ (= Max ({<[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= Max ([SALES_INVOICES.YEAR]))}>} [SALES_INVOICES.PERIOD]))}
>} PREV_HECTO_QUANTITY))

Regards,
Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
2 Replies
try below

Somme ({<
[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= (max ([SALES_INVOICES.YEAR])))},
NUM_MOVEMNT_DATE = {"=NUM_MOVEMNT_DATE=NUM_JOUR_OUVRABLE"},
[STR_S_PREVISIONS_VENTES.PERIOD] = {\$ (= Max ({<[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= Max ([SALES_INVOICES.YEAR]))}>} [SALES_INVOICES.PERIOD]))}
>} PREV_HECTO_QUANTITY)

or
if( NUM_MOVEMNT_DATE=NUM_JOUR_OUVRABLE,
Somme ({<
[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= (max ([SALES_INVOICES.YEAR])))},
[STR_S_PREVISIONS_VENTES.PERIOD] = {\$ (= Max ({<[STR_S_PREVISIONS_VENTES.YEAR] = {\$ (= Max ([SALES_INVOICES.YEAR]))}>} [SALES_INVOICES.PERIOD]))}
>} PREV_HECTO_QUANTITY))

Regards,
Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Contributor II
Author

merci