Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

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)

17 Replies
anbu1984
Master III
Master III

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

QSense
Creator II
Creator II
Author

It didnt work unfortunately

ashfaq_haseeb
Champion III
Champion III

Try like this

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

Regards

ASHFAQ

QSense
Creator II
Creator II
Author

It didnt work unfortunately

ashfaq_haseeb
Champion III
Champion III

Can you post your sample application to look at.

Regards

ASHFAQ

anbu1984
Master III
Master III

Can you post sample app

QSense
Creator II
Creator II
Author

It's data big volume I can not share unfortunately

ashfaq_haseeb
Champion III
Champion III

maxgro
MVP
MVP

put your expression in a chart (no dimension, just an expression)

remove label

hover the mouse over the label and look at the popup with your expression, you should see the date instead of the function; compare the format of the date with ANSWERTIME in a listbox, or post the screen (popup and listbox)