Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Contributor II
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)
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.

View solution in original post

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.

View solution in original post

Contributor II
Contributor II

merci