topic Re: Total and expression total in straight table in QlikView

Total and expression total in straight table

Tue, 10 Jul 2012 07:32:26 GMT

i Have multiple dimensions in a staight table, different expresions for each dimension which will be set with a variable. Problem is I want expression total and Total both rows, i get any one row among these two.

In a table with single dimension it work. I have checked 'show Total' in dimension limits tab and checked 'expression total' in expressions tab.

Please guide me with this.Thanks

Re: Total and expression total in straight table

giakoum — Tue, 10 Jul 2012 07:36:24 GMT

Add a new expression where you add columns, and take that new expressions total.

column(1) + column(2)

for example. not sure what you mean though...

Re: Total and expression total in straight table

Tue, 10 Jul 2012 07:40:53 GMT

I want two separate rows one below other, first total row which is just sum and below that expression total for which i have written expression.

in expression i have taken it as row 0.

Re: Total and expression total in straight table

Tue, 10 Jul 2012 07:41:34 GMT

I want two separate rows one below other, first total row which is just sum and below that expression total for which i have written expression.

in expression i have taken it as row 0. As the expression total is of row number 0.

Re: Total and expression total in straight table

giakoum — Tue, 10 Jul 2012 07:55:02 GMT

You cannot have two sum rows as far as I know. Duplicate your expression and do the different totaling there.

Re: Total and expression total in straight table

Wed, 11 Jul 2012 07:15:20 GMT

I can have two sum rows, one is expression total, other is just a sum of that column. In my expression i have written

if(rowno()=0, netsales*3, netsales)

netsales is a field name. this is working when I have only one dimension but in a straight table i have 5 dimensions, its not working there

Re: Total and expression total in straight table

Jason_Michaelides — Wed, 11 Jul 2012 07:26:02 GMT

I think you had better post an example app or at least a screenshot so we can understand you better.

Jason

Re: Total and expression total in straight table

giakoum — Wed, 11 Jul 2012 07:28:03 GMT

try if(rowno(total)=0, netsales*3, netsales) but an example should server well.

Re: Total and expression total in straight table

Wed, 11 Jul 2012 07:48:41 GMT

rowno(total)=0 is not working.

I have attached a eg. snapshot