topic How to create static Pivot table in QlikView

How to create static Pivot table

Tue, 02 Sep 2014 08:59:13 GMT

I want to create a static Pivot Table irrespective of selections.

Thanks

MK_QSL — Tue, 02 Sep 2014 08:59:55 GMT

You can create such type of Pivot Table (sometimes Balance Sheet) using Valuelist Function....

Consider that you have below data..

Load * Inline

[

Customer, Sales, Qty

A, 100, 10

B, 200, 20

C, 300, 30

D, 400, 40

E, 500, 50

];

Create a pivot table

Dimension

=ValueList('Total Sales', 'Total Qty')

Expression

IF(ValueList('Total Sales', 'Total Qty')='Total Sales', SUM({1}Sales),

IF(ValueList('Total Sales', 'Total Qty')='Total Qty', SUM({1}Qty)))

Anonymous — Tue, 02 Sep 2014 09:02:48 GMT

Or maybe set the Pivot Table to a dedicated Alternate State, thus it will not be affected selections on the default $ state.

ashfaq_haseeb — Tue, 02 Sep 2014 09:03:12 GMT

Hi,

Can you explain what are you trying to achieve.

May be you can use Alternate state for the same.

Regards

ASHFAQ

JonnyPoole — Tue, 02 Sep 2014 14:19:48 GMT

In each expression add the global SET IDENTIFIER

ex:

change: sum(Sales)

To: sum( {1} Sales)

No selection will impact the chart as long as ALL expressions have the identifier {1}

rustyfishbones — Tue, 02 Sep 2014 14:29:43 GMT

Use Alternate States.

Create your table as normal and Add an alternate state of State1, like below

And then change the state of your pivot table to State1