Discussion Board for collaboration related to QlikView App Development.
Hi, can any one please create a pivot table using attached sample excel data..
You have three tabs in there? What is your expected output?
Make a pivot table and drag the specific dimension on the header.
Thanks & Regards
I need city wise type1,type tech and type name sales as every type has different expression
Please elaborate more on your requirement,what are the expressions for each type
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.
Please check the attached app.
Can u tell me what exactly output you are looking for ?
concatinate the tables with renaming the values and valuble to value... then take pivot table dim-->city,techtype,type1,typename exp-->sum(value)