# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New 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)

Tags (1)
Labels (1)
• ### Set

1 Solution

Accepted Solutions

## Re: Set analysis : 2 champs égaux

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

## Re: Set analysis : 2 champs égaux

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.
New Contributor II

merci

Tags (1)