topic Re: Dynamically dimensions and expressions in pivot in QlikView

Dynamically dimensions and expressions in pivot

Fri, 30 Sep 2016 15:28:54 GMT

Hello,

I have a dashboard with 5 pivot tables that appear or disappear pressing different buttons.

This tables are quite heavy, so I need to do something to keep the application as fluid as possible.

I tought to create a single table that changes dimensions and expressions dynamically pressing each button (avoiding to put all the dimensions and expressions in the table and hiding one or another).

Is it possible to do something like that?

Thanks in advance

Re: Dynamically dimensions and expressions in pivot

rupamjyotidas — Fri, 30 Sep 2016 16:01:51 GMT

You can use Conditional box for both 'Dimension' and 'Equation'

Please keep in mind if the tables are too heavy, it always good to limit the User to select something before they can view the Pivot.

Re: Dynamically dimensions and expressions in pivot

Mon, 03 Oct 2016 07:53:53 GMT

Hi, thanks.

I've already tried to do in that way with all the dimensions and expressions in the table and showing or hiding one or the other at the push of each button. The application was working fine, but I was wondering if it's possible to do the same thing but sending each time the parameters to the pivot without having all the elements already in it.

Any idea?