Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

1 pivot table with conditional columns (11) or 8 pivot tables inside a container?

Hi,

I want to know your opinion in this matter, mainly considering the performance.

The thing is that I need to see the same expressions (10) splitted differently when there is a selection.

So at this moment I have a main pivot table with a first dimension called measures, and for some of that measures another views are needed (with different columns).

So what I can do is create 7 predefined pivot tables inside a container that you can move on between.

Or insert all the columns inside the pivot tablet and create some logic with the selection of the measures.

What do you think will have better performance, or how can I test this?

Further to this, how can be measured the size of an object (in this case pivot table) and it's performance implication in a Qlikview report?

Thanks

Ginés.

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: 1 pivot table with conditional columns (11) or 8 pivot tables inside a container?

The only way to be sure is to test both options. My guess is that one pivot table with conditional expressions will work best.


talk is cheap, supply exceeds demand