Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Set analysis : 2 champs égaux

merci

Tags (1)