Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

QSense
Not applicable

question about set analysis

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)

4 Replies
ashfaq_haseeb
Not applicable

Re: question about set analysis

Hi,

Go through this post

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

Regards

ASHFAQ

QSense
Not applicable

Re: question about set analysis

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

ashfaq_haseeb
Not applicable

Re: question about set analysis

Attach Sample data.

Or contact me

My skypeID: ashfaqhaseeb

Regards

ASHFAQ

giakoum
Not applicable

Re: Re: question about set analysis

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)