Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

quser_learn
New Contributor III

Data Model for Pivot table

I have data coming in the following structure.

CustomerTerritoryProductProduct Sub CategorySalesOpportunity
Cust1120AA1$150 300
Cust2130AA1$0 300
Cust3120AA2$100 300

and would like to show the following tables in the dashboard.   When the user selects "A1" from Object 1, I'd like show both the cust 1 and cust 2 in the straight table.  My question is - is it good idea to create a temp table in the Pivot table form while loading the data itself or is there a why we can achevie this just with the base table ?

Pivot Table Object 1.

ProductProduct Sub CategorySalesTotal OpportunityMkt share
AA1$150 900$0.17
AA2$100 900$0.11

Straight Table Object 2

CustomerTerritoryProductProduct Sub CategorySalesOpportunity
Cust1120AA1$150 300
Cust2130AA1$0 300
Cust3120AA2$100 300

Thanks !

1 Solution

Accepted Solutions
Highlighted
quser_learn
New Contributor III

Re: Data Model for Pivot table

I used set analysis and conditional statements and solved it.

View solution in original post

3 Replies
Not applicable

Re: Data Model for Pivot table

Hi quser_learn,

     I found no problem selecting A1 and seeing Cust2 in the second object. I think I don't understand your question:

Capture.PNG

quser_learn
New Contributor III

Re: Data Model for Pivot table

Yeah ..question is how to show the market share as 0.17 and opportunity as 900 as opposed to 1 in object 1

Highlighted
quser_learn
New Contributor III

Re: Data Model for Pivot table

I used set analysis and conditional statements and solved it.

View solution in original post