Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

pranubitla
New 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

1 Solution

Accepted Solutions

Re: Replicate number of days with in quarter for two date fields

But which object are we trying to do this in? Or is this something you need across your object? If it is for a specific object, would you be able to mention what are the expected numbers you are looking to get once you make your selection of Q1?

View solution in original post

10 Replies

Re: Replicate number of days with in quarter for two date fields

Where are you looking to do this? What is the expected output?

Capture.PNG

Re: Replicate number of days with in quarter for two date fields

I don't find any entry date in your data

pranubitla
New Contributor II

Re: Replicate number of days with in quarter for two date fields

I am planning to show number of days from Entry date to Insite date

see the attached screenshot please.

pranubitla
New Contributor II

Re: Replicate number of days with in quarter for two date fields

Hi Sunny,   I would like to show number of days from Entry date to Insite Date,  example user select Quarter from list box, data from Process2 field ( see edit script line 12) number of days should filtered with in Q1.

hope I am not confusing you.

pranubitla
New Contributor II

Re: Replicate number of days with in quarter for two date fields

Kaushal, See the entry date highlighted in yellow ColumnC from the attachment

pranubitla
New Contributor II

Re: Replicate number of days with in quarter for two date fields

see the attached screenshot.

My Actual result vs Expected result.  number of days from Entry date to Insite date

Please help.

Re: Replicate number of days with in quarter for two date fields

But which object are we trying to do this in? Or is this something you need across your object? If it is for a specific object, would you be able to mention what are the expected numbers you are looking to get once you make your selection of Q1?

View solution in original post

pranubitla
New Contributor II

Re: Replicate number of days with in quarter for two date fields

Hi Sunny,

I am using this for only one specific object  when I select Q1 I should get only 3 items for Process 2

see attached screenshot please

Re: Replicate number of days with in quarter for two date fields

Got it, I think what you need here is a Canonical Date