topic Re: Pivot Table in QlikView

Pivot Table

nareshthavidishetty — Sun, 27 Sep 2015 13:36:42 GMT

Hi, can any one please create a pivot table using attached sample excel data..

sunny_talwar — Sun, 27 Sep 2015 13:42:36 GMT

You have three tabs in there? What is your expected output?

Anonymous — Sun, 27 Sep 2015 13:43:29 GMT

hi naresh,

Make a pivot table and drag the specific dimension on the header.

Thanks & Regards

Neetha

nareshthavidishetty — Sun, 27 Sep 2015 16:23:42 GMT

I need city wise type1,type tech and type name sales as every type has different expression

type

Anonymous — Sun, 27 Sep 2015 16:57:39 GMT

Please elaborate more on your requirement,what are the expressions for each type

mazacini — Sun, 27 Sep 2015 18:18:46 GMT

As other posters have indicated, you need to be more specific.

There are a variety of pivot options available from the information you have provided.

Here is one.

qlikviewwizard — Mon, 28 Sep 2015 03:52:03 GMT

Hi,

Please check the attached app.

nagarjuna_kotha — Mon, 28 Sep 2015 04:18:34 GMT

Can u tell me what exactly output you are looking for ?

pratap6699 — Mon, 28 Sep 2015 12:11:32 GMT

concatinate the tables with renaming the values and valuble to value... then take pivot table dim-->city,techtype,type1,typename exp-->sum(value)