# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
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.
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.
Contributor II

merci

Tags