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

Announcements
Data Works for AI is here - Join the discussion and enter to win a pair of Qlik kicks: Join the Conversation!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter on last 90 days of records

My SQL query and QlikView set analysis is giving me different results.

I am trying to get a unique user login stats in last 90 days.

In QlikView I have the same Oracle tables as I have in my SQL query

My dimension is EMP_GEO and expression is:

Count( {<LOGONDATE{">=$(=date(max(LOGONDATE)-90,'MM/DD/YYYY'))"}>} distinct NTID)

MY SQL is:

select emp_geo, count(distinct ntid) from plmprd.trackuserlogin t1, userdata t2
where t1.reqid = t2.ntid (+) and logondate > (select sysdate -90 from dual) group by emp_geo;

What am I doing wrong?

Labels (1)
0 Replies