topic Re: Pivot table Problem in QlikView

Pivot table Problem

Mon, 18 Nov 2013 08:20:47 GMT

Hi Everyone,

Here i'm not getting that how to show the report in this type of format in Pivot table.. the format is as below-

I want to show on the top Gross Sales in one column. In Gross Sales column we want to show the different five column

PY , Target, Act , vs PY% and PY. as in the below fig . I am unable to do this .

Please anyone help me how to do these things.

Mon, 18 Nov 2013 08:34:28 GMT

Hi Manoj,

Are Gross Sales, Qty, and Gross Margin all in the same dimension (or field)?

If so, then just drag and drop that dimension on top of your expressions (horizontally).

Regards.

Mon, 18 Nov 2013 08:34:32 GMT

Hi,

You can use Pivoting to do this.

Press the left mouse button and keep it depressed while dragging the mouse cursor up above the expression label row.

For using this, make sure that Allow Pivoting option is enabled in Presentation tab.

I hope this help you

Regards,

Ashutosh

tresB — Mon, 18 Nov 2013 08:49:04 GMT

See this link, might help you: Merge headers in pivot table