Discussion board where members can get started with QlikView.
1: i want last 3 months of data in 3 Qvds based on the field case "CaseClose" .
2: If "Case_Key" is not closed ,i need to put 'CaseClose' as "NotClosed"
How to achieve this
thanks in advance.
May be this?
If(Len(Trim(CaseClose)) = 0, MonthName(Today()), MonthName(CaseClose)) as CaseClose_Temp
(ooxml, embedded labels, table is Sheet1);
FOR i = 0 to -2 step -1
Where Num(CaseClose_Temp) = Num(MonthName(AddMonths(Today(), $(i))));
LET vStore = Date(AddMonths(Today(), $(i)), 'MMMYYYY');
STORE Temp into $(vStore).qvd (qvd);
DROP Table Temp;
View solution in original post
Then where would the data go if the CaseClose is not closed?
if caseclose is not there please add that to current date
Hi sunny i opened new thread Issue In Splitting QVD's please look on it.