Help with set analysis

[aminehaddar]

Hello,

I have this expression:

=SUM({<

P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},

RIGHT(P_DATE_OUVERTURE,2) = {'=RIGHT($(ANNEE_EXTRACTION),2)'}

>}P_MONTANT_PRODUCTION)

When I delete  RIGHT(P_DATE_OUVERTURE,2) , the error is taken.

But I can't handle without the condition in red.

Any help please?

Regards.

[jonathandienst]

The LHS of set expressions must be a physical field name, so you cannot use Right(...) there. Options are

• create a derived field using

          RIGHT(P_DATE_OUVERTURE,2) as Derived

          and use this field in the set expression

• use this expression

        P_DATE_OUVERTURE = {"=$(=RIGHT(P_DATE_OUVERTURE,2) = RIGHT($(ANNEE_EXTRACTION),2)"}

         (success will depend on the data structure in your document)

[qlik4asif]

You can create a field in backend with RIGHT(P_DATE_OUVERTURE,2) as XXXXX,

Use this field the expression

=SUM({<

P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},

XXXXX = {'=RIGHT($(ANNEE_EXTRACTION),2)'}

>}P_MONTANT_PRODUCTION)

[aminehaddar]

Thanks for your answer.

I edited like this:

=SUM({<

P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},

P_DATE_OUVERTURE = {'=$(RIGHT(P_DATE_OUVERTURE,2)

=RIGHT($(ANNEE_EXTRACTION),2)'}

>}P_MONTANT_PRODUCTION)

The expression is ok.

But when I press the apply button, I find this error: error in set modifier ad hoc element: ; or ') , strange no?

Regards

[aminehaddar]

I tried it before posting my problem.

But the system doesn't accept a field in backend in the place of the attribut.

Regards

[qlik4asif]

If P_DATE_OUVERTURE is a field 

Then you can create new field in backend

RIGHT(P_DATE_OUVERTURE,2) as XXXXX,

[aminehaddar]

syntax error bro

[qlik4asif]

can u share qvw or code which you used

[jonathandienst]

Corrected expression

SUM({<

P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},

P_DATE_OUVERTURE = {'=$(=RIGHT(P_DATE_OUVERTURE, 2)

=RIGHT(ANNEE_EXTRACTION, 2))'}

>} P_MONTANT_PRODUCTION)

[sunny_talwar]

Try this may be

=Sum({<P_DATE_PRODUCTION = {"<=$(DATE_EXTRACTION)"}, P_DATE_OUVERTURE = {"=RIGHT(P_DATE_OUVERTURE, 2)

= RIGHT($(ANNEE_EXTRACTION), 2)"}>} P_MONTANT_PRODUCTION)

2 things I changed

1) Remove dollar sign expansion on top of RIGHT function for your P_DATE_OUVERTURE

2) Use double quotes for search string

Quotes in Set Analysis