Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

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
Champion III
Champion III

Hi,

Go through this post

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

Regards

ASHFAQ

QSense
Creator II
Creator II
Author

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
Champion III
Champion III

Attach Sample data.

Or contact me

My skypeID: ashfaqhaseeb

Regards

ASHFAQ

giakoum
Partner - Master II
Partner - Master II

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)