Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Khan
Creator III
Creator III

How to put non matching records between two dates in qlikview at front end

Hi Team,

   I wanted to compare two dates value and need to show only those records which are not present in previous month last day and

present in current month last day i.e i wanted to exclude all common record between these two dates and put only non-matching records.

I have tried the below expression

varibale define

for getting last day of current  month

vLastDayPrevMon=MonthEnd(AddMonths($(vFromDate), -1))

LastDayCurrMon=MonthEnd($(vToDate))

=if(Date='$(vLastDayPrevMon)' AND Date='$(vLastDayCurrMon)',ID)

KK
1 Reply