topic Re: Hiding Partial Sum in QlikView

Hiding Partial Sum

rohitians — Wed, 19 Jun 2013 05:18:52 GMT

Hello,

I have inventory report where in i have quantity ,rate and Value..

The Dimensions are Product Name and Vendor Name....

Here when showing Sub total i want to hide the sub total for Rate and only show sub total for Quantity and Value..

How can i do that what would be code n where do i need to write..

I am attaching the sample report format..

Thanks and Regards,

Rohit

Re: Hiding Partial Sum

Wed, 19 Jun 2013 05:31:45 GMT

Hi,

You can use like below,

IF(RowNo()=0 or IsNull(RowNo()),'',Sum(Rate))

Karthik

Re: Hiding Partial Sum

Wed, 19 Jun 2013 06:03:07 GMT

when showing Sub total

you want to hide the sub total for Rate and only show sub total for Quantity and Value..

then

take a straight table--

dimension1-- Product Name

dimension2-- Vendor Name

Expression1-- sum(PurchaseQty)

Expression2--PurchaseRate

Expression3-- sum(POValue)

see sample attached file.

Re: Hiding Partial Sum

rohitians — Wed, 19 Jun 2013 06:05:47 GMT

Hello Karthik,

Thanks

But where do I write this code..

Explain and want to show total quantity and Value and I want to hide the rate coulmn's total whose code is

if (SUM({$<DocumentType_Code={1}/*,OS_Purch_Qty={">0"}*/>}PurchaseLine_Qty)>0,AVG(Purchaseline_UnitCost),0).

Thanks and Regards,

Rohit

Re: Hiding Partial Sum

Wed, 19 Jun 2013 06:12:21 GMT

Write "Rate" column expression like below,

IF(RowNo()=0 or IsNull(RowNo()),'',if (SUM({$<DocumentType_Code={1}/*,OS_Purch_Qty={">0"}*/>}PurchaseLine_Qty)>0,AVG(Purchaseline_UnitCost),0))

Logic behind above expression is, RowNo() function will reply 0 if that row is subtotal and RowNo() function will reply empty value if row is GrandTotal. So for Rate column we are forcely giving "Null" value in Subtotal and Grand Total.

Re: Hiding Partial Sum

Wed, 19 Jun 2013 06:30:34 GMT

Hey Vishwaranjan,

hw u did tht, viewed ur application bt didn understand????

Re: Hiding Partial Sum

er_mohit — Wed, 19 Jun 2013 07:20:19 GMT

For purchase rate write this expression

If(Dimensionality()=2,sum(PurchaseRate))

hope it helps you

Re: Hiding Partial Sum

rohitians — Wed, 19 Jun 2013 11:04:36 GMT

Thanks,

Everyone for Helping,

Karthik Mohit Vishwaranjan..