Discussion Board for collaboration related to QlikView App Development.
I am having the below requirement.
I am having few gates associated with Actual Dates against multiple programs.
For Example :
Likewise, there are multiple programs each associated with a gate and actual date
My requirement is to find out Average of Gate 6 actual date minus Gate 1 actual date for programs in the quarter
Also, % of programs with duration 6 months or less in the quarter.
Could you please help me with the solutions for this.
I have tried in all the possible ways, but i am unable to find out a solution for this.
Thanks in advance,
Can you provide some sample data with expected output please? You can use set analysis for calculating average.
Below is the sample data
PRG_ID, Gate, Actual Date
Expected Output is like
|Programs < 6 months duration||15%||13%||20%||15%|
Please do the needful.
Actual dates for Gate 1 in the given date set are null. So whats your logic when its null? should we consider Min Date for the respective ID as Gate 1- Actual Date
For suppose 7-11-2016 for ID 12363.
What is the duration calculated in? Like Days or hours ? Some of your Gate 1 dates are null what you want them to be replaced with?
Duration needs to be in months.
Actual Date Null Values to be replaced with nothing.
we will consider only the values which are not null.
No, we should not consider any min date.
It should be calculated only when the value is not null.