Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this.
SET vSommeCA = '=sum({$<DateFacture={">=$(=Min(Date))<=$(=Max(Date))"}>}FACT_LIGNE.CAHT)';
Regards,
Kaushik Solanki
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.)