Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

set analysis script

Hello,

I wrote a set analysis statement caluclates between max(answertime) -1 and max(answertime)

but ıi does not bring any values.

I am probably making mistake .

Could you help me

=sum({$<ANSWERTIME={">=$(date(max(ANSWERTIME)-1,'DD.MM.YYYY 00:00:00')) <$(=date(max(ANSWERTIME),'DD.MM.YYYY 00:00:00'))"}>}CALL_AMOUNT)

Labels (1)
1 Reply
QSense
Creator II
Creator II
Author

=sum({$<ANSWERTIME={">$(=date(max(ANSWERTIME)-10,'DD.MM.YYYY hh:mm:ss')) <=$(=date(max(ANSWERTIME),'DD.MM.YYYY hh:mm:ss'))"}>}CALL_AMOUNT)

this is true.