Qlik Community

App Development

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

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Yedikapi
Contributor II
Contributor II

add string to variable

Hi,

I'm trying to add Time into the variable and so to search my CorrectionTime

Sum({< CorrectionTime={">(=$(varBeginDatum)+ ' 00:00:00')<=(=$(varEindDatum) + ' 23:26:00')"}>} Qty_Recipe_Correction)

Result is always 0 .

I'm actually trying the sql statement

WHERE c.CorrectionTime >= @dateFrom
AND c.CorrectionTime <= DATEADD(MINUTE, 26, DATEADD(HOUR, 23, CAST(@dateTo as datetime)))

What is incorrect ? Can someone help me, please ?

Labels (1)
1 Solution

Accepted Solutions
Henric_Cronström

It depends on the format of CorrectionTime and the format of your variables, but I would try something like

Sum({<CorrectionTime={">$(=TimeStamp(varBeginDatum))<=$(=TimeStamp(varEindDatum+'23:26:00'))"}>} Qty_Recipe_Correction)

View solution in original post

1 Reply
Henric_Cronström

It depends on the format of CorrectionTime and the format of your variables, but I would try something like

Sum({<CorrectionTime={">$(=TimeStamp(varBeginDatum))<=$(=TimeStamp(varEindDatum+'23:26:00'))"}>} Qty_Recipe_Correction)