Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
how can i do something like this in qlik sense? in the sheet as a table
use ValueList('Sales','Budget','Margin','%',Out of stock') as a dimension
and as a measure use something like:
pick(match(ValueList('Sales','Budget','Margin','%',Out of stock'),'Sales','Budget','Margin','%',Out of stock')
,Num(Sum(Sales),'$#,##0.00')
,Num(Sum(Budget),'$#,##0.00')
,Num(Sum(Margin),'$#,##0.00')
,Num(.....Margin calculation......,'#,##0.0%')
,Num(Sum(OutOfStock),'#,##0')
)