Discussion board where members can get started with Qlik Sense.
I'm trying to find a way to create a field from data located in other fields.
Basicly, form the table below, How can i find the latest value for the item 1 if the message is B.
The result should be 10.
For information, this operation is done in the script. All the values found are then put together in a field in order to easily find them in qlik sense when a ID item is called.
Thank you for your time,
You want to do this in the script? You want to store this in a new column? May be this
Left Join (TableName)
LOAD [ID item],
FirstSortedValue(Value, -Date) as Recent_Value
Group By [ID item], [Message];
After a few tries, This works :
load "ID item"
FirstSortedValue([value],-if([message] like 'B' ,[date]))
As "value of interest"
resident TableName group by "ID item";