Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
kkhozema
Contributor II
Contributor II

How do I read the value of master group record?

I am trying to do as below:

TempItemMaster:

LOAD * INLINE [

OrgCode, ItemNumber, ProcessiongTime

1000, PartNumber1, 15

581, PartNumber1, 10

600, PartNumber1, 40

581, PartNumber2, 16

600, PartNumber2, 16

2000, PartNumber2, 12

];

ItemMaster:

NoConcatenate

LOAD OrgCode,

ItemNumber,
ProcessiongTime,

AutoNumber(Recno(), ItemNumber) as Rank,
If(ItemNumber = Previous(ItemNumber), RangeSum(Peek('RankPeek'), 1), 1) as RankPeek

Resident TempItemMaster

ORDER BY ItemNumber DESC, OrgCode asc;

DROP Table TempItemMaster;

 

 

Annotation.png

What i need is as follows

 

Annotation (1).png

 

2 Replies
Kushal_Chawda

@kkhozema  try below in your resident load 

if(ItemNumber<>previous(ItemNumber), ProcessingTime & ' Value Derived from '&OrgCode& ' | ' &ItemNumber, peek(PreProcessingTime)) as PreProcessingTime

kkhozema
Contributor II
Contributor II
Author

It works on the sample data set. But not on the actual data.

I need is to work on a bigger dataset.

I will try to explain better