topic Re: Subtotals in straight table in QlikView

Subtotals in straight table

sebdupont — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I know the option to get sub totals in a straight table by using show totals in the Dimension Limit Tab.

But i have a problem to get a subtotal by city in my example

What i want

Country	Region	City	item	quantity
USA	Florida	Miami	A	5
USA	Florida	Miami	B	10
		Total		15
USA	Florida	St Pete	A	10
		Total		10
	Total			25
USA	California	Los angeles		30
		Total		30
	total			30
Total				55

What i get

Country	Region	City	item	quantity
USA	Florida	Miami	A	5
		Total		5
USA	Florida	Miami	B	10
		Total		10
USA	Florida	St Pete	A	10
		Total		10
	Total			25
USA	California	Los angeles		30
		Total		30
	total			30
Total				55

If i want the country subtotal, i have to select show total in region dimension

If i want the region subtotal, i have to select show total in city dimension

logically, if I want the subtotal of the city, I select the item subtotal, but instead of making me a subtotal per city , it adds a subtotal for each items

The Quantity expression, is a simple sum.

I try to use a hiding dimension with no succes.

I hope to have been clear with this simple example, my app is a little more complex

Can someone help me ?

Re: Subtotals in straight table

Arthur_Fong — Mon, 26 Aug 2019 23:56:10 GMT

There you go.

You missed out a step to sort dimensions based on priority.

I did it both on straight table and pivot table and it works well.

Refer qvw attached to check on the configurations I did.

Thanks and regards,

Arthur Fong

Re: Subtotals in straight table

sebdupont — Tue, 27 Aug 2019 06:55:58 GMT

Thanks Arthur, your simple example help me to understand where i was wrong

A simple column sorting problem.

Thanks again.

Re: Subtotals in straight table

sugathirajkumar — Tue, 27 Aug 2019 10:04:09 GMT

sort->Region->Numeric VAlue->Decending

Re: Subtotals in straight table

sugathirajkumar — Tue, 27 Aug 2019 10:05:47 GMT

Re: Subtotals in straight table

sebdupont — Wed, 28 Aug 2019 12:49:42 GMT

Thanks for your help