Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attaching problem pic and expected result pic.
please let me know how it is possible to get result pic.
problem pic:-
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
];
hi
plz share expression, license fr qliview is over
Expression
=Count([Account No])
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
Not sure what you mean? May be you need The Generic Load