Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

shiveshsingh
Valued Contributor III

Script for this output

I am attaching problem pic and expected result pic.

please let me know how it is possible to get result pic.result.JPG

problem pic:-

problem.JPG

5 Replies
MVP
MVP

Re: Script for this output

May be this

LOAD *,

  Month(MonthStart(Date, Jump*(IterNo()-1))) as Month

While IterNo() <= Freq;

LOAD *,

  12/Freq as Jump;

LOAD * INLINE [

    Account No, Freq, Date

    10001, 12, 03-04-2015

    10002, 1, 05-06-2015

    10003, 4, 03-02-2015

    10004, 4, 05-07-2015

    10005, 2, 04-04-2015

    10006, 2, 07-07-2015

];


Capture.PNG

shiveshsingh
Valued Contributor III

Re: Script for this output

hi

plz share expression, license fr qliview is over

MVP
MVP

Re: Script for this output

Expression

=Count([Account No])

shiveshsingh
Valued Contributor III

Re: Script for this output

how can we expand month to column, like jan, feb, march should be a newcolumn..

when i m loading, those are coming in one column i.e. month

MVP
MVP

Re: Script for this output

Not sure what you mean? May be you need The Generic Load