Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a flat file that just has a list of dates. I pulled that file into qlik to match against the other dates to work as some sort of master date filter. if one of the calculated dates = the date from the flat file, then a count of all of the ones that match will pop up based off of the calculation. EX. Flat file date is 01/01/2024. All records that have there "Created date" as 01/01/2024 will be counted in the Created Column, All records that have there "Cancelled date" as 01/01/2024 will be counted in the Cancelled column. The problem is it is not working. I have formatted alll of the dates to match the same formatting as mm/dd/yyyy. Im setting a created measure to be if( CalcDateCreate = Dates, Count(ID)) but nothing is populating.
Hi,
Can you share the script...