Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
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
Employee
Employee

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

)