https://community.qlik.com/t5/Data-Movement-Streaming/Date-streamliing/m-p/2157566#M1705 <P>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&nbsp;if( CalcDateCreate = Dates, Count(ID)) but nothing is populating.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Jaylon_0-1704216812580.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/126438i4BDDAE3E77F0C18B/image-size/medium?v=v2&amp;px=400" role="button" title="Jaylon_0-1704216812580.png" alt="Jaylon_0-1704216812580.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 22:43:16 GMT Jaylon 2025-03-19T22:43:16Z https://community.qlik.com/t5/Data-Movement-Streaming/Date-streamliing/m-p/2157566#M1705 <P>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&nbsp;if( CalcDateCreate = Dates, Count(ID)) but nothing is populating.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Jaylon_0-1704216812580.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/126438i4BDDAE3E77F0C18B/image-size/medium?v=v2&amp;px=400" role="button" title="Jaylon_0-1704216812580.png" alt="Jaylon_0-1704216812580.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 22:43:16 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Date-streamliing/m-p/2157566#M1705 Jaylon 2025-03-19T22:43:16Z https://community.qlik.com/t5/Data-Movement-Streaming/Date-streamliing/m-p/2157791#M1707 <P>Hi,</P> <P>Can you share the script...</P> Wed, 03 Jan 2024 09:46:20 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Date-streamliing/m-p/2157791#M1707 Parthiban 2024-01-03T09:46:20Z