Grouping

[#1]

Hi All,

I'm trying to turn this data into a Regional wise information. It's so easy to do it in MS Excel's Pivot table but couldn't manage to do it in Qlikview.

This is what I want to see:

I've put the Brand as a dimension, and tried using Expressions with If clauses but it's not working. For instance for column A:

If([Region]='A', Sum[Sales],'')

but it's not working.. any idea?

Thanks,

Mem

[Miguel_Angel_Baeyens · Accepted solution]

Hello Mem,

There are at least two ways to get that done. Create a new chart, pivot table, set Brand as dimension and create one expression per each region

Sum({< Region = {'A'} >} Sales)

This is acceptable since you only have three regions and hardcoding them may have some sense.

But it will work as well in a pivot table, Brand and Region as dimensions, Sum(Sales) as expresion, expanding Brand, and pivoting Region to the top horizontal of the table. Then in the properties of the chart, Presentation tab, select Region, Show Partial Sums, and Subtotals at bottom.

This will work regardless the number of regions you have.

Hope that helps.

[boorgura]

Mem,

please refer to the attached example.

[#4]

thanks both, spot on!

Mem