Discussion Board for collaboration on QlikView Scripting.
i managed it to do using a variable as below.
but i was wondering if i can avoid one more resident load and instead hust load 2 values from 2 variables in load statement like . It doesn't give any error but no values in the table.
SUMB1:LOAD'B-A' as SGroup,($(vB) - $(vA))as StockValue;
can you try preceding load
Load'A-B' as Desc,(ValueB-ValueA) as Value ;
LOADIF(Desc='B', Value) as ValueB ,IF(Desc='A', Value) as ValueAFROM [lib://Source/Grouping.xlsx](ooxml, embedded labels, table is Sheet1) where WildMatch(Desc,'B','A') ;