topic Re: need logic help. in QlikView

need help.

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

What is FieldValue() ? What is the restriction on this function?

Re: need logic help.

MindaugasBacius — Tue, 07 Jun 2016 07:58:13 GMT

There is no attachment.

Or please just explain the logic of the result.

Re: need logic help.

krishna20 — Tue, 07 Jun 2016 08:01:22 GMT

What is you requirement?? Please let us know, then only someone can reach you with a suitable ideas.

Re: need logic help.

Kushal_Chawda — Tue, 07 Jun 2016 08:06:57 GMT

What is logic to get the output?

Re: need logic help.

MK_QSL — Tue, 07 Jun 2016 08:21:54 GMT

Input:
Load *, Item & '|' & MonthYear as Key;
LOAD [Item Code] as Item, 
     Rate, 
     [Wef Date] as WDate,
     Date(MonthStart([Wef Date]),'MMM-YYYY') as MonthYear,
     1 as Flag
FROM
Test.xlsx
(ooxml, embedded labels, table is Sheet1);


TempTable:
Load Distinct Item Resident Input;
Join
Load Distinct MonthYear Resident Input;




Concatenate(Input)
Load * Where Not Exists(Key);
Load Item, MonthYear, Item & '|' & MonthYear as Key Resident TempTable;


Left Join (Input)
Load Item, Date(Min(MonthYear),'MMM-YYYY') as MinMonthYear Resident Input
Where Flag = 1
Group By Item;


Final:
Load 
  Item,
  MonthYear,
  If(Item = Previous(Item) and MonthYear < MinMonthYear, 0,
  If(Item <> Previous(Item) and MonthYear < MinMonthYear, 0,
  If(Item = Previous(Item) and MonthYear = MinMonthYear, Rate,
  If(Item = Previous(Item) and MonthYear > MinMonthYear and Not IsNull(Rate), Peek('Rate'),
  Peek('Rate'))))) as Rate
Resident Input
Order By Item, MonthYear;


Drop Table Input;

Re: need logic help.

lalitkgehlot89 — Tue, 07 Jun 2016 09:22:00 GMT

Plz let me know to delete it.