Discussion board where members can get started with Qlik Sense.
I'm not able to show the company data, so I made up a similar senario:
A fruit store sells apple and banana. They have t1 to track the sales, t2 for linking, t3 for tracking number of visiting the store:
Type key Sales
Apple 1 20
Banana 2 40
I'm creating a pivot table with row: Type, with measures: Sales and Visit. Now it looks like:
It's counting Visits by Type as well. But I want to show total visits at both Apple and Banana. which should be like:
Is it possible to do it from the layout?
Thanks for help!!!
sum(total <Type> Visit) as a new mesure for visit should do it as far as type is a dimension
maybe with a new measure as below:
sum( total Visits )
Load * inline [
Measure: sum(Total [t1.Visit])