Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
JackSkelhorn
Contributor
Contributor

Percentage Calculation

I have a table that identifies the top 6 suppliers for a specific product type based on sales. The table also includes measures to calculate Gross Profit and Sales Mix %. I have a separate dimension (Monthly Margin Dim) which splits these values by previous month (Oct 2022), 2022 YTD and 2021 YTD.

The Sales Mix % formula (see below) works perfectly when I make a selection i.e. 2022 YTD.  When I remove my Monhtly Margin Dim selections the calculation stops working. 

Sales Mix % formula:

Sum({<[Product Forecast Category]={'GENERATORS'},[Product Group Description]={'Boilers'}>} [Sales Invoice Line Amount])
/
Sum(TOTAL[Sales Invoice Line Amount])

I have tried including <[Monthly Margin Dim]> in the denominator and numerator but this doesn't work either. 

Any suggestions? 

 

Labels (4)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

please post an app with sample data

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

please post an app with sample data

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.