I'm trying to load my "Master Table" into qlikview twice.
Here's my situation. I have 3 tables I've concatenated, and then created a Master Calendar for, based on a data, Date Created, However, these tables also have another date that I would like a Calendar for, and I'm trying to create another Master Table, and Master Calendar, based off of Resolution Date.
My issue: My Resolution Date contains "NULL" Values, since not everything has been "Resolved", so this is messing up my Master Calendar whenever I am trying to find the MIN date, it's finding NULL.
Is there any way around this?
Maybe adding a clause:
IF(ISNOTNULL([Resolution Date], MAX([Resolution Date])) AS MinDate,