Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)