Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Script Problem

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

1 Solution

Accepted Solutions
Highlighted

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

View solution in original post

4 Replies
Highlighted

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

Highlighted
Creator II
Creator II

if caseclose is not there please add that to current date

Highlighted

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

View solution in original post

Highlighted
Creator II
Creator II

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