Discussion Board for collaboration related to QlikView App Development.
I have a question , and please help me with some ideas.
I`m importing some info from my database on which I`m creating kpi`s.
The problem is that in my DB some Dates are missing.
So I`m having this :
For each date I have created some kpi`s (kpiName and kpiNo). In my interface it will look something like this
What I`m trying to do is to add the missing date (07/05/2017) and to put on Value column 0 for each kpi. something like the table below:
I`ve achieved to add the missing date by adding this code in Script:
min(HIST_DATE) as MinPeriod,
max(HIST_DATE) as MaxPeriod
date(MinPeriod - 1 + IterNo()) as HIST_DATE
while(MinPeriod + IterNo() - 1) <= MaxPeriod;
But the problem is that in my table I can`t see any kpi for 07/05/2017.
Do you have any Idea how can I add the missing rows ?
I can`t post the code here but it will be helpful if you can give me some ideas.
Nevermind , I`ve resolved.
I forgot to add in MinMax and tempDate the kpiNo and kpiName columns.
You could just create a Master Calendar, connect it to your data on the date field and use the master calendar fields in the charts. This will allow you to analyze by dates, months, quarters, etc.