topic Re: Date Comparison in Set Analysis in QlikView

Date Comparison in Set Analysis

markabrom — Mon, 16 Sep 2019 18:03:42 GMT

I have a requirement where I need to use a filter to select a date, then pass the date into a variable. In Set Analysis I need to compare the variable to a Trans date and then return rows that are less than or equal to the variable.

The date format is 9/5/2017 4:24:16 PM

I have tried set analysis

Sum({1<Set_status_date="<=Timestamp($(P_date),'M/D/YYYY hh:mm:ss TT')">}Amount)

How Can I make this work?

Re: Date Comparison in Set Analysis

Vegar — Mon, 16 Sep 2019 18:12:37 GMT

I've made some adjustments to your expression, I hope it helps.

Sum({1< Set_status_date={"<=Timestamp#('$(P_date)",'M/D/YYYY hh:mm:ss TT')"}>}Amount)

Re: Date Comparison in Set Analysis

Brett_Bleess — Thu, 26 Sep 2019 20:36:34 GMT

In addition to Vegar's post, I wanted to add the following, might help a bit more:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett