Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have few fields which I display in my qvw file. Now I need to store these field values everyday and use it later to plot a trending graph.
For example: I have a variable $(vPass) and $(vFail). Everyday these values will be updated. I don't want to loose the previous days values and want to plot a trending graph based on no. of days.
Can you please guide me how I can store the values and later use it to plot values.
I am using excel data as my input.
Thanks
Can't you create variables like $(vPass_Constant) and $(vFail_Constant) and for dynamic like $(vPass) and $(vFail)
After you have calculated the pass/fail values and populated vPass and vFail, append into a qvd file like this:
History:
LOAD $(vPass) as Pass,
$(vFail) as Fail,
Now() as Timestamp
Autogenerate 1;
If Alt(QvdCreateTime('History.qvd'), 0) > 0 Then
Concatenate(History)
LOAD Pass, Fail, Timestamp
FROM History.qvd (qvd);
End If
Store History into History.qvd (qvd);
Hi,
Above script is giving me below error.
Syntax error, missing/misplaced FROM:
History:
LOAD as Pass,
as Fail,
Now() as Timestamp
Autogenerate 1
History:
LOAD as Pass,
as Fail,
Now() as Timestamp
Autogenerate 1
You need to populate the variables vPass and vFail before using this script fragment.
Hello Jontydkpi,
Can you please give me a sample example. I am very new to qlikview.
Sample Data I have:
Month, Item, Status
Jan, A, In Progress
Jan, B, Completed
Jan, C, Completed
Feb, D, In Progress
Feb, E, Completed
Feb, F, In Progress
So now, for Jan, Pass = 2 (sum of Completed ones), Fail = 1 (sum of In Progress)
For Feb, Pass = 1 (only 1 Completed), Fail = 2
$(vPass) = Count({<QA Status = {'Completed'}>} Item)
$(vFail) = Count({<QA Status = {'In Progress'}>} Item)
These 2 variables are set using Settings->Variable Overview
Requirement:
1) Need to create a qvd every night which will store Month, $(vPass), $(vFail), Item, Date
2) later use this qvd to create a trend graph (monthwise) .
Can you please help.