Custoom totals in Straight table

[Anonymous]

IS there any way to define our own custom expression to define totals in straight table .

I have a strange requirement where i neeed to calculate Totals in which i have drilldown .I have three levels in drilldown .

Store

Department

Section.

My requirement is if i drill down to department totals for store should be displayed but data should be for deparment only.

And same    for the section also.For both Dept and Section totals should be Store .

IS there any way to  achievve

Thanks

[datanibbler]

Hi,

this sounds similar to something I had to do some time ago.

You cannot do this with the automatic totals which QlikView calculates, so you will have to make your own.

=> The totals must not be part of the straight_table, but individual objects (textboxes?) above the table.

=> You can set up your straight_table with those three fields as dimension with

- the 2nd one active when some selection has been made on the first;

- the 3rd one active when some selection has been made on the second;

That will get kind of difficult when it comes to keeping with a constant layout when the straight_table_chart changes with the data.

HTH

Best regards,

DataNibbler

[krishna_2644]

post some sample data or a QV document which demonstrated your problem.

The same issue we had for a pivot table.

[Anonymous]

Hi

Thanks for reply

Unfortunately i couldn't post the app due to its size.

[krishna_2644]

Atleast Some sample data to get an idea of what you are looking for.

If thats not possible, post a demo document.

[jonathandienst]

You can use the Dimensionality() function to customise the expression for the total (at least in a pivot, I am not so sure about a straight table).

Does it have to be a straight table?

[Anonymous]

Thanks for reply!

Yes it should be in Straight table .

[Anonymous]

Store	Customers
totals	62714
011 MOE	19767
003  City Ctr	15149
010 Mall	4397
016 Mall	2974
015  Ctr	11547
009	8880

Hi

If you observe Customer column in the above  table .It consists of total  count of its customers.

My requirement is I want total to be customized .

In the above table total for customers at country level.

If i drill down to nxt level Dept level ,Then totals should be at store levels (i.eSum(Cutomers) at store level) and data should be for Dept .

[jonathandienst]

Sounds like a pivot to me...

[Kushal_Chawda]

Please share the sample data