topic Re: question about set analysis in QlikView

question about set analysis

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

Hello ,

I have an issue and curious about this.

I want to make set analysis like that ı have date column(A) and ı would like to find last day of this date column

It look like that

sum(A>max(A)-1 <A<max(A) > B)

Re: question about set analysis

ashfaq_haseeb — Tue, 30 Sep 2014 13:36:59 GMT

Hi,

Go through this post

http://community.qlik.com/docs/DOC-4708

Regards

ASHFAQ

Re: question about set analysis

QSense — Tue, 30 Sep 2014 13:42:34 GMT

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)

This is my statement.

I can not solve with document you sent

Re: question about set analysis

ashfaq_haseeb — Tue, 30 Sep 2014 13:44:29 GMT

Attach Sample data.

Or contact me

My skypeID: ashfaqhaseeb

Regards

ASHFAQ

Re: Re: question about set analysis

giakoum — Tue, 30 Sep 2014 13:45:11 GMT

put the expression in variables and try again

there is an equal sign missing by the way :

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)