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: 
hafaneh
Contributor III
Contributor III

Table

hafaneh_0-1701844405267.png

Hello,
how can i do something like this in qlik sense? in the sheet as a table 

1 Reply
jochem_zw
Partner Ambassador
Partner Ambassador

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')

)