Expression in Variable

[christophebrault]

Hi,

I'm using variable to store expression, but it's not working for a specific one :

LET vSommeCA = 'sum({$<DateFacture={">=$(=Min(Date))<=$(=Max(Date))"}>}FACT_LIGNE.CAHT)';

Any idea ?

Thanks

[kaushiknsolanki]

Hi,

     Try this.

     SET vSommeCA = '=sum({$<DateFacture={">=$(=Min(Date))<=$(=Max(Date))"}>}FACT_LIGNE.CAHT)';

Regards,

Kaushik Solanki

[kuba_michalik]

Had a look at your script, and the problem was what I thought it would be.

Try this for assignment in script:

SET vSommeCA = 'sum({$<DateFacture={">=$^^(=Min(Date))<=$^^(=Max(Date))"}>}FACT_LIGNE.CAHT)';
LET vSommeCA = Replace('$(vSommeCA)','^^','');

Then it works (use $(vSommeCA) in any expressions, otherwise QlikView will treat the variable as text.)