Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
olguita2014
Creator
Creator

transform formula to script

Hi,

Help me please!!!!..... I want to put this expression Sum({<KARFECHA={"<=$('$(=MAX(KARFECHA))')"}>} Cantidad_Saldo) into the script.

 

 

Labels (1)
3 Replies
uacg0009
Partner
Partner

Hi,
some questions:
1.what's the data type of "KARFECHA"? a date?
2.do you want to put it in a table? if yes, what's the dimensions/columns of this expression?
3.how about putting it into a variable in script?
Aiolos Zhao
olguita2014
Creator
Creator
Author

Hi,

Please help me!!!!!!.... I want to get the last record of city  by date range. Example:

I have this information:

vehicle modelcityDATE
AAAA11/2/2017
AAAA228/2/2017
AAAA323/2/2019
BBBB118/2/2017
BBBB223/3/2018
BBBB317/2/2019

 

and when I choose one date, for example 23/3/2018 (rate of dates less or equal to the current selection)the result should be:

DATE 23/3/2018

vehicle modelcity
AAAA2
BBBB2

 

if i select this DATE 23/2/2019

 

vehicle modelcity
AAAA3
BBBB3

 

uacg0009
Partner
Partner

Hi Olguita,

I think below is what you want, please see the attachment:

transform formula to script2.PNGtransform formula to script1.PNG

Aiolos Zhao