Dates filter out by Selection

[#1]

Hi All,

I have three dates here; orderdate, billdate, and paymentdate. I have to use SET analysis and need to filter out these dates according to the selection please help. I am new to SET Analysis. Can someone help me apply the below filters in SET.

Thanks in advance,

1) orderdate <= selected year/month or is null
2) billdate >= selected year/month or is null
3) Transaction billed GrossAmount is not $0
4) paymentdate is in the selected year/month

5) GrossAmount = > Contractlinebilling

[Gysbert_Wassenaar · Accepted solution]

Please post a small qlikview document that illustrates the problem.