Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Channa
Specialist III
Specialist III

Calculating Percentage while using ValueList Dimension

Dimension1: Month

Dimension 2:=ValueList('LocalSales','Export','IntercompanySales')

Measure :=pick(match(ValueList('LocalSales','Export','IntercompanySales'),'LocalSales','Export','IntercompanySales')
,sum(LocalSales),sum(Export),sum(IntercompanySales))

 

for Total :sum(LocalSales)+sum(Export)+sum(IntercompanySales)

i need to calculate %

MonthSalesTypeValueTotalSalePercentage
JANLocalSales10024004.166666667
JANExport2000240083.33333333
JANIntercompanySales300240012.5

 

i need help to get last  measures Percentage

salesType is not direct Dimension i used valueList

Channa
Labels (1)
1 Reply
Channa
Specialist III
Specialist III
Author

it works with below thank you

=pick(match(ValueList('LocalSales','Export','IntercompanySales'),'LocalSales','Export','IntercompanySales')
,sum(LocalSales),sum(Export),sum(IntercompanySales))/

(sum(LocalSales)+sum(Export)+sum(IntercompanySales))

Channa