topic Re: TOTAL - Set Analysis in QlikView

TOTAL - Set Analysis

zagzebski — Tue, 27 Aug 2013 11:18:31 GMT

Data:

Client Month Sales

A Jan 100

A Feb 50

B Jan 200

B Feb 100

I know this should be simlpe but I am drawing a blank on how to incorporate the TOTAL function. What I want to be able to do is add the total for each month regardless of the client:

Object:

Client Month Sales

A Jan 300

B Jan 300

A Feb 150

B Feb 150

Re: TOTAL - Set Analysis

CELAMBARASAN — Tue, 27 Aug 2013 11:19:35 GMT

May be with this

Sum(Total<Month> Sales)

Re: TOTAL - Set Analysis

kaushiknsolanki — Tue, 27 Aug 2013 11:20:52 GMT

Hi,

Try this.

Sum(total<Month>Sales)

Where Client and Month is the dimension.

Regards,

Kaushik Solanki

Re: TOTAL - Set Analysis

MayilVahanan — Tue, 27 Aug 2013 11:24:31 GMT

PFA

Re: TOTAL - Set Analysis

zagzebski — Tue, 27 Aug 2013 13:40:10 GMT

Thanks - helped a lot!

Re: TOTAL - Set Analysis

Tue, 27 Aug 2013 13:59:40 GMT

In Straight Table Chart, take dimension as Month ans expression as sum(Sales). It will give you monthly total and grand total.

Re: TOTAL - Set Analysis

zagzebski — Tue, 27 Aug 2013 14:54:39 GMT

I was slightly off in what I needed. I needed to segment by year:

Data:

Client Month Sales Year

A Jan 100 2013

A Feb 50 2013

B Jan 200 2013

B Feb 100 2013

A Jan 75 2012

A Feb 50 2012

B Jan 100 2012

B Feb 75 2012

Object results:

Client Month Sales-2103 Sales-2012

A Jan 300 175

B Jan 300 175

A Feb 150 125

B Feb 150 125

Basically have to add Set analysis by year to this expression:Sum(total<Month>Sales)... but I must have my syntax wrong because I am coming back with blanks.