topic Re: Grand Total in Expression in QlikView

Grand Total in Expression

Mon, 25 Nov 2013 10:17:35 GMT

I am sharing a file, Whcih is quite interesting. I want Grand Total in my Last Column i.e. - Test1. Value should be 59, Please don't change in logic. Which is correct, Only grand total should be 59 which is coming in subtotal.

Thanks in Advance.

Re: Grand Total in Expression

MK_QSL — Mon, 25 Nov 2013 10:42:47 GMT

IF(Dimensionality() = 1, Column(1) * Column(7))

Re: Grand Total in Expression

MK_QSL — Mon, 25 Nov 2013 10:43:34 GMT

IF(Dimensionality() = 1, Column(1) * Column(7),Column(1) * Column(7))

Re: Grand Total in Expression

Mon, 25 Nov 2013 10:48:52 GMT

Grand total is coming 726722.50, Which is worng. Clear All and check. the same expression.

Re: Grand Total in Expression

CELAMBARASAN — Mon, 25 Nov 2013 11:14:44 GMT

Hi,

Are you looking for this

If(RowNo() = 0 or Dimensionality() = 0, Column(1) * Column(7), 0)

Hope it helps

Re: Grand Total in Expression

Mon, 25 Nov 2013 11:20:26 GMT

Thanks for reply, But in this condition My Grand Total is coming 726722.5.

If u will export the whole chart in excel in XLS. check the Total - It is 35097.36. I want this value.

Re: Grand Total in Expression

CELAMBARASAN — Mon, 25 Nov 2013 12:07:22 GMT

The QV file you uploaded gives me 32539586872.5682

Where Outlook = 36075839

SS Adh % SKU = 901.977272727273

Result is correct as per the logic. I didn't get how it is wrong?

Re: Grand Total in Expression

Mon, 25 Nov 2013 14:28:43 GMT

Hi Amit,

You can try following Expression

(if(rowno()=0,

(column(1)*column(7)) ,

if(ISNULL(RowNo())

if(IsNull(RowNo()),SUM(AGGR(sum(aggr(

if((sum(aggr(((sum(ClosingStock))/((((sum(Outlook))*(avg([Safety Stock Norm])))/30))),CalendarDate,[2nd Item Number])))>1,1,

if((sum(aggr(((sum(ClosingStock))/((((sum(Outlook))*(avg([Safety Stock Norm])))/30))),CalendarDate,[2nd Item Number])))>0.7 and

(sum(aggr(((sum(ClosingStock))/((((sum(Outlook))*(avg([Safety Stock Norm])))/30))),CalendarDate,[2nd Item Number])))<=1,0.5,0)) /vMaxDay,CalendarDate,[2nd Item Number]))

*SUM(Outlook)

,[2nd Item Number])))

,0)) )