Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QSense
Contributor 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
Honored Contributor III

Re: script

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

QSense
Contributor II

Re: script

It didnt work unfortunately

Re: script

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
Contributor II

Re: script

It didnt work unfortunately

Re: script

Can you post your sample application to look at.

Regards

ASHFAQ

anbu1984
Honored Contributor III

Re: script

Can you post sample app

QSense
Contributor II

Re: script

It's data big volume I can not share unfortunately

Re: script

MVP
MVP

Re: script

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)

Community Browser