topic Re: How to create a pivot table with independent dimensions. in Qlik Learning Discussions

How to create a pivot table with independent dimensions.

sateeshkumar — Thu, 11 Sep 2014 06:23:15 GMT

I have Requirement that showing actual,previous,target values by product wise (showing in one row in top of the table ). And also I need to show these for dimensions (all are independent) ex: Sales,Market share,growth % like this... i.e i need sales for actual,previous,growth values by product wise.. Can Anyone help this..

Thanks in advance.

Re: How to create a pivot table with independent dimensions.

Fri, 12 Sep 2014 19:54:01 GMT

I'm having trouble visualizing this. Can you provide a sample of what you need?

Re: How to create a pivot table with independent dimensions.

sateeshkumar — Mon, 15 Sep 2014 05:59:31 GMT

Thank you for your response. I want to show a pivot table like this..

showing A1,B1,C1 values ex: actual,previous,target values by all products showing prod name top (by using scrollbar) for Metrics ex: sales,growth,share like dimensions. I cant do it by using different tables for each metric because i have many products to show by using scrollbar. If I scroll one table other wont scroll so It is not possible by dng this.

All are independent one having different expressions.

Pls help me to solve this problem..

Re: How to create a pivot table with independent dimensions.

sateeshkumar — Mon, 15 Sep 2014 11:10:50 GMT

Yeah i got the solution for above Problem by using ValueList we can create a temporary dimension having custom metrics.

I think the below link is helpfull

http://community.qlik.com/thread/49885

Thank you.