Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Need Groupwise Total

Dear All;

If I am having a data similar to mentioned below in the table

Sr NoArticle NumberBrandPriceQtyTotal Price
1A1201110550
2A2201110550
3B3200910550
4B9200910550
5C9201010550
6A92010205100
7A72010205100
8A82010205100
9A92011205100
10C72011255125
11C92009255125
12C32011255125
13C152011255125
14C122011305150
15A152011305150

and then as a result i need the Brandwise Sum of Total Price like..

BrandTotal Price
2009225
2010350
2011875

I am not able to get the Groupwise Total????

Thanks in Advance!

Shantanu    

1 Solution

Accepted Solutions

Need Groupwise Total

Hi Shantanu,

It is very simple take

Dimension = Brand

Expression = Sum( [Total Price] )

it will give result that you want.

Rgds

Anand

3 Replies
sridhar240784
Contributor III

Re: Need Groupwise Total

Shantanu,

Have a look at the attached appliaction.

-Sridhar

Need Groupwise Total

Hi Shantanu,

It is very simple take

Dimension = Brand

Expression = Sum( [Total Price] )

it will give result that you want.

Rgds

Anand

Re: Need Groupwise Total

Hi,

See the attached sample file.

Rgds

Anand

Community Browser