topic Re: How to not evaluate $ sign in QlikView

How to not evaluate $ sign

patrickbender — Wed, 02 May 2018 10:06:54 GMT

Hi i have the following variable set up at the end of the LOAD script:

Set SelectSpKostnader = FirstSortedValue({<Målkortsdatum ={"<=$(=SVDate)"}>}[SP Kostnader],-[Målkortsdatum]);

SInce the $ sign evaluates duing the load statement it is not dynamic afterward and doesn't refer to the variable anymore.

Futhermore as the variable is empty during the loadscript the end result is like this:

FirstSortedValue({<Målkortsdatum ={"<="}>}[SP Kostnader],-[Målkortsdatum])

Any Ideas of how to avoid this?

I want this variable to load as it is on the second row.

Thank you for all the amazing help i get from this forum

olivierrobin — Wed, 02 May 2018 10:09:54 GMT

replace $ par chr(36)

and rewrite your command by using chr(39) for single quote

example :

set vSetAnalysis_MaxMois_M_1= 'Mois=,id_mois={' & chr(39) & chr(36) & '(vMax_Mois_M_1)' & chr(39) & '}';

tresB — Wed, 02 May 2018 10:22:48 GMT

May be just try with LET like:

LET SelectSpKostnader = 'FirstSortedValue({<Målkortsdatum ={"<='&'$'&'(=SVDate)"}>}[SP Kostnader],-[Målkortsdatum])';

patrickbender — Wed, 02 May 2018 10:46:40 GMT

Thank you!

I tried both and they worked very well, I marked the second answer as correct because that's what I ended up using as that was easier to read.