topic Re: Subtotal within a Dimension in QlikView

Subtotal within a Dimension

cupelix-qlik — Fri, 21 Mar 2014 09:41:09 GMT

Is it possible to have 2 Sub totals within a single Dimension.

What I have is:

Date

Dispatch Area - This contains 8 Different Dispatch Areas 4 for the North & 4 for the South. So North areas start with NEOC and South areas start with SEOC

Data Fields

So what I would like to show on my data is: Where North or South is shown this will be the sub total. This needs to appear in the same column.

21/3/14 NEOC1 Data Values

21/3/14 NEOC2 Data Values

21/3/14 NEOC3 Data Values

21/3/14 NEOC4 Data Values

21/3/14 North Data Values

21/3/14 SEOC1 Data Values

21/3/14 SEOC2 Data Values

21/3/14 SEOC3 Data Values

21/3/14 SEOC4 Data Values

21/3/14 South Data Values

Re: Subtotal within a Dimension

MK_QSL — Fri, 21 Mar 2014 09:43:39 GMT

Please provide your sample data file...

Re: Subtotal within a Dimension

cupelix-qlik — Fri, 21 Mar 2014 09:49:51 GMT

I dont have a sample data file, I have shown above what I need. The Data Values are just Interger Values

Re: Subtotal within a Dimension

preminqlik — Fri, 21 Mar 2014 09:54:35 GMT

Load *,

if([Dispatch Area]=NEOC*,'North',

'South') as Region

From

XXX;

Now in frontend add dimension named "Region '

use subtotal for that

Re: Subtotal within a Dimension

cupelix-qlik — Fri, 21 Mar 2014 10:04:46 GMT

Thanks for the answer, is it possible to do without changing the Load Script

Re: Subtotal within a Dimension

preminqlik — Fri, 21 Mar 2014 10:10:20 GMT

yes in front add calculated dimension

if([Dispatch Area]=NEOC*,'North',

'South')

Re: Subtotal within a Dimension

cupelix-qlik — Fri, 21 Mar 2014 10:43:55 GMT

Unfortunately that adds an additional Column, what i need is to have the subtotal appear in the same column as the dispatch area, if this isn't possible then thats fine I just need to know one way or the other