Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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 - Specialist
Partner - Specialist

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 - Specialist
Partner - Specialist

Hi Olguita,

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

transform formula to script2.PNGtransform formula to script1.PNG

Aiolos Zhao