Allow modifications in Access Point

[#1]

Hello everyone,

I have created an application which contains a pivot table. I would like users in Access Point to be able to add and remove dimensions in this pivot table.

It doesn't work. When I try by right clicking on the pivot table and going to properties, I cannot add or remove dimensions...

But when I create a new object (still from access point), I then, can create a pivot table and add and remove dimensions.

Why can I create a new object but not modify an existing one ?

Thanks for your answer

[alexandros17]

It depends from publisher settings but I think this is a very dangerous situation because users could select wrong dimensions to be used with your expression.

I usually (in these cases) add all useful dimension and hiede / show them with variables and check boxes

[JonnyPoole]

Consider the approach on the 'ad-hoc' tab of this public demo.  In this sheet users can select a pivot table or straight table and select dimensions and measures from a list.

QlikView

Uses hide/show conditions to display the fields the user wishes.

[#4]

Hi Alessandro,

the solution you propose sounds perfect, I didn't know we could do it like this.

Could you tell me how to do it ?

I don't even know how I can add a check box...

Can the pivot table change according to the variable ? Or do I need to create as many pivot tables as there are possible combinations and then display only the right one ?

Thank you

[markodonovan]

Hi Laura,

I'm guessing it is because the object is your own when you copy it rather than a shared object.

It would be nice if the user could alter the objects themselves and be able to restore to the original if required.

I had this problem recently when a user wanted to add 1 field to a table.

As an alternative you could try making the dimensions conditional using the following expression:

=Alt(

WildMatch(

GetFieldSelections(%Dimensions, '|'),

'*MyDim1*')

,0)

Add the following inline table:

// Load the list of dimensions

DimensionList:

Load * Inline [

%Dimensions

MyDim1

MyDim2

];

Then create a listbox using the %Dimensions field so users can select the dimensions they wish to use.

Thanks

Mark

http://www.techstuffy.com

[Peter_Cammaert]

And to answer your question: all objects that reside in the original QVW are immutable: they cannot be changed and their properties remain grayed out in the Access Point. You may be able to move or resize them, if the corresponding checkboxes have been disabled by the designer.

There is a simple explanation for this behavior: these objects only exist in the QVW, they're not server objects that can be managed by the server itself. And even the QlikView server will never modify an original QVW.

A copy of an existing object, now that's a completely different story: that's a real server object, though it looks exactly the same as the original. Server objects can be changed in the AP by whoever has access to them. The server will store their properties in a special file outside of the QVW.

Peter

[alexandros17 · Accepted solution]

Load inline a list of fields (dimension) (Change name to the fields)  (The column is : DescrCampo)

use a listbox and in presentation set stile window checkboxes.

in the condition field of your table write:

Index(GetfieldSelections(DescrCampo,',',50), 'myField)>0

or

Index(GetfieldSelections(DescrCampo,',',50), '*)>0

That is if you find among the list of selectable fields  (Dimension to hide and show) The DescrCampo value identical to your field (One of the field of the list (One for each column to display) then the column is visible.

[#8]

Thank you

Have a good day