Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

More Than 2 Condition (Date Comaprison) in Set Analysis expression

In this application i m having one date field that is
-Recivedate , another one date field that is First Disb date.(I am using this one to
make selection.....) now i want one more expression in union to that
this expression ...
Where if Recieve Date is greater than First disb date(or in other
words -Month(RecivedDate )should be greater than Month (Selected)
---This field is coming from First DISB Date then all my fileno from
aug2001 to till my selection.......

Can you suggest me sumthing ......
You can just gimme suggestison(in set analysis) rest i can apply ....
According to me expression should be like this...

=COUNT( {1<YM={">=$(=MonthName(DATE('

28/08/2001')))<=$(=MAX(YM))"}, Rmonth={">MonthName'}>}
DISTINCT FILENO)
But this is not working .....
Any guesses

QVW(Doccument ) is attached for your understanding and refrence..........
0 Replies