topic Re: Help needed on Pivot table in QlikView

Help needed on Pivot table

Mon, 31 Oct 2011 07:42:49 GMT

Dear All,

I have pivot table like

Product Group	Product Name	Sales Qty.	Sales Value	Return Qty.	Return Value

it is OK and working properly. Now I Want to change this like

Product Group	Product Name	Sales		Return
		Qty. Value		Qty. Value

Please help me to do this.

anilsknp

Help needed on Pivot table

Mon, 31 Oct 2011 08:17:14 GMT

Hi,

To do this, you need to have a dimension like Sales and Return.

Based on the type, the value will be present under the dimension.

Regards,

Srini.

Re: Help needed on Pivot table

Mon, 31 Oct 2011 09:00:19 GMT

hi, Sri

yes I have a field trnType in which 'Sales', 'Return' Is comming but required result is not comming

i am attaching sample QV file

Regards

anilsknp

Re: Help needed on Pivot table

Mon, 31 Oct 2011 11:12:10 GMT

Hello anilsknp,

try to use 'trnType' as a third dimension in your pivot, like anilsknp mentioned above. In your example data is only one value ('Invoice') but take a look at the modified app anyway :

HtH

Roland

Re: Help needed on Pivot table

Mon, 31 Oct 2011 12:34:53 GMT

Dear Sir,

Your sample QV file is exact what I need, but when I am taking the "trnType" as 3rd Dim then result if differ

please tell me that how i can set this field or value of field horizontally

best regards

anilsknp

Help needed on Pivot table

Mon, 31 Oct 2011 13:26:38 GMT

No, I just checked the "trnType" and it has just "Invoice".

I even checked "Source Code", it has Just "SALES".

Please check the data and updated the file.

Regards,

Srini.

Re: Help needed on Pivot table

Mon, 31 Oct 2011 13:41:34 GMT

Hi, Sri

yes this field have only one value that is "Invoice".

Please tell me that how can I use this trnType field as 3rd Dim as Roland used Because when I am using this as 3rd Dim then value of this field showing vertically for this I checked Presentation Tab in Pivot propertie but I cant find any option for it.

Here I am attaching both QV Files

1. Test My sample

2. 38138.Test Roland sample

Well If I can used this trnType Field just like Roland then I got answer of my query.

Thanaks & Regards

anilsknp

Re: Help needed on Pivot table

Mon, 31 Oct 2011 17:25:17 GMT

Hi,

No, what i thought was you can have a new field called "SubTransType".

That field will have only two values i.e., "Sales" and "Returns".

What ever the condition you use here, you can use the same logic in the script for the table.

So, you don't need to calculate that many expressions. Example : if you want Value and Qty then you just need two expressions.

One is sum of Value and next is Sum of Qty.

With the same report, add this new dimension and drag it and drop it horizontally. So you will get the same design of the report.

Regards,

Srini.