Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pranubitla
Contributor II
Contributor II

Replicate number of days with in quarter for two date fields

Dear Experts, please see below sample app.

I would like to replicate number of days within Q1  from [Entry Date]  to  [Insite Date]

(Entry date should be in Q1 and Insite date (should be in Q1)  )

please help

10 Replies
pranubitla
Contributor II
Contributor II
Author

Hi Sunny I tried to implement using canonical dates, but I could not get the right result. could be the reason my  all date fields coming from the single table. Can you please help