Discussion Board for collaboration related to QlikView App Development.
I have data for a period of time from which i have taken out minimum and maximum date.
Now i have a list of processes. I want to create a dummy data by looping the dates.
Say minimum date is 12 Dec 2015 and Maximum Date is 15 Dec 2015.
and consider processes : process1, process2 and process3.
Then I want to create data in qlikview though script as :
How to this?
Can anyone help?
So your first step would be to calculate the Min & Max Date
min(Date) as MIN_DATE
max(Date) as MAX_DATE
group by Process;
'Row '&RowNo() as Row,
date(MIN_DATE+IterNo()-1,'DD MMM YYYY') as Date
DROP Table Data;
View solution in original post
LOAD Process,date(date#(MaxDate,'DD MMM YYYY'),'DD MMM YYYY') as MAX_DATE,
date(date#(MinDate,'DD MMM YYYY'),'DD MMM YYYY') as MIN_DATE Inline [
Process, MaxDate, MinDate
Process1, 15 Dec 2015, 12 Dec 2015
Process2, 15 Dec 2015, 12 Dec 2015
Process3, 15 Dec 2015, 12 Dec 2015 ];
Thanks for the quick response
But the minimum date, maximum date and processes provided by me are static.
While the list of processes and date will be dynamic and change as per the data.
Thanks a lot for the help.
I have one more query related to this.
As mentioned I have a table with the fields: Process, Date, [Value]
Which looks like
14 Dec 2015
And after using the below script :
I get :
whereas I want
Please help me with your valuable knowledge.