topic Re: Script Problem in QlikView

Script Problem

d_koti24 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

PFA

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

pls help

thanks in advance.

Thanks& Regards,

Koti

sunny_talwar — Tue, 26 Apr 2016 08:35:15 GMT

Then where would the data go if the CaseClose is not closed?

d_koti24 — Tue, 26 Apr 2016 08:43:32 GMT

if caseclose is not there please add that to current date

sunny_talwar — Tue, 26 Apr 2016 08:52:00 GMT

May be this?

Raw:

LOAD CaseOpen,

Case_Key,

CaseClose,

If(Len(Trim(CaseClose)) = 0, MonthName(Today()), MonthName(CaseClose)) as CaseClose_Temp

FROM

Raw.xlsx

(ooxml, embedded labels, table is Sheet1);

FOR i = 0 to -2 step -1

Temp:

NoConcatenate

LOAD CaseOpen,

Case_Key,

CaseClose

Resident Raw

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;

NEXT

d_koti24 — Fri, 29 Apr 2016 04:59:18 GMT

Hi sunny i opened new thread Issue In Splitting QVD's please look on it.