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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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