topic Grouping in QlikView

Grouping

Tue, 15 Mar 2011 17:01:08 GMT

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

Grouping

Miguel_Angel_Baeyens — Tue, 15 Mar 2011 17:19:52 GMT

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.

Grouping

boorgura — Tue, 15 Mar 2011 17:28:40 GMT

Mem,

please refer to the attached example.

Grouping

Tue, 15 Mar 2011 17:36:17 GMT

thanks both, spot on!

Mem