Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kylealpaugh
Contributor
Contributor

sub total in chart with out demenions

I have a chart with 5 dimensions and 4 expressions. 

I want to be able to only show one of the dimensions in the straight table the only problem is when i don't have all the dimensions in the chart it the sub total and numbers are off. I was able to hide some of the dimensions by going to presentation and clicking on hide but it still shows values i just want to see the sub total number is that possible ?pice big.PNGprice small.PNG

 

The top chart is with all the dimensions and the bottom chart is what i was able to get it down to. I want to show only the dimension company and only the sub total of it.

1 Reply
bharathadde
Creator II
Creator II

Try below in the expressions, i'm assuming field name of Company is 'Company' and Expression fields names are header names.

Price Mvmt

Sum(Total <Company>[Price Mvmt])

2018 Sales YTD

Sum(Total <Company>[2018 Sales YTD])

2019 Sales YTD

Sum(Total <Company>[2019 Sales YTD])

%Growth

=(Sum(Total <Company>[2019 Sales YTD])-Sum(Total <Company>[2018 Sales YTD]))/Sum(Total <Company>[2018 Sales YTD])

Hope it helps you