topic Re: script in QlikView

script

QSense — Tue, 30 Sep 2014 10:24:42 GMT

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)

Re: script

anbu1984 — Tue, 30 Sep 2014 10:38:05 GMT

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

Re: script

QSense — Tue, 30 Sep 2014 11:07:30 GMT

It didnt work unfortunately

Re: script

ashfaq_haseeb — Tue, 30 Sep 2014 11:12:21 GMT

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

Re: script

QSense — Tue, 30 Sep 2014 11:19:05 GMT

It didnt work unfortunately

Re: script

ashfaq_haseeb — Tue, 30 Sep 2014 11:19:55 GMT

Can you post your sample application to look at.

Regards

ASHFAQ

Re: script

anbu1984 — Tue, 30 Sep 2014 11:21:16 GMT

Can you post sample app

Re: script

QSense — Tue, 30 Sep 2014 11:24:29 GMT

It's data big volume I can not share unfortunately

Re: script

ashfaq_haseeb — Tue, 30 Sep 2014 11:30:46 GMT

Hi,

Go through this post

Preparing examples for Upload - Reduction and Data Scrambling

Regards

ASHFAQ

Re: script

maxgro — Tue, 30 Sep 2014 11:38:24 GMT

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)

Re: script

er_mohit — Tue, 30 Sep 2014 11:39:53 GMT

Try this

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

this

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

Re: script

QSense — Tue, 30 Sep 2014 12:32:27 GMT

I added two print screen

Re: script

QSense — Tue, 30 Sep 2014 12:37:37 GMT

Re: script

ashfaq_haseeb — Tue, 30 Sep 2014 12:42:14 GMT

Your first part is missing and you have different date format.

Try like below

=sum({<ANSWERTIME={">=$(Timestamp(max(ANSWERTIME)-1,'DD/MM/YYYY hh:mm:ss')) <$(=Timestamp(max(ANSWERTIME),'DD/MM/YYYY hh:mm:ss'))"}>}CALL_AMOUNT)

Regards

ASHFAQ

Re: script

anbu1984 — Tue, 30 Sep 2014 12:45:00 GMT

Your ANSWERTIME format doesn't match format of date(max(ANSWERTIME)-1,'DD.MM.YYYY 00:00:00'))

Change format of date command to match with ANSWERTIME format

=sum({<ANSWERTIME={">=$(Timestamp(max(ANSWERTIME)-1,'DD/MM/YYYY hh:mm:ss TT')) <$(=Timestamp(max(ANSWERTIME),'DD/MM/YYYY hh:mm:ss TT'))"}>}CALL_AMOUNT)

Re: script

QSense — Tue, 30 Sep 2014 13:00:11 GMT

It didnt work again

Re: script

anbu1984 — Tue, 30 Sep 2014 13:51:24 GMT

Is ANSWERTIME in DD/MM or MM/DD? Accordingly fix format in Timestamp. Did you use TT in Timestamp format?

Re: script

QSense — Tue, 30 Sep 2014 18:50:47 GMT

format is MM/DD I changed with this format it still does not work