Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Pivot Table

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

8 Replies
sunny_talwar

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

neetha_p
Master
Master

hi naresh,

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


Thanks & Regards

Neetha

nareshthavidishetty
Creator III
Creator III
Author

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

type
neetha_p
Master
Master

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

mazacini
Creator III
Creator III

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
Master II
Master II

Hi,

Please check the attached app.

Capture.PNG

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

pratap6699
Creator
Creator

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