topic Re: Lock Pivot table in QlikView

Lock Pivot table

Tue, 01 Apr 2014 14:14:40 GMT

Dear community,

Attached herewith the sample, I have pivot table with InputSUM column which should be locked.

If i select either Detached or Read Only, i will not able to change the value in InputSUM column, so that is not a good idea.

How should i lock this table so that user is unable to filter or select any selection from this table while they still can edit data in the inputSUM column?

The purpose of asking this is because user might accidentally filter some selections by miss clicking some cells, when entering data in inputSUM column.

Original table:

Accidentally clicking 100 that make filter to that row: (undesirable)

Desirable result: (But Detached is not a good solution as mentioned above)

Thanks,

Chanel

Re: Lock Pivot table

its_anandrjs — Tue, 01 Apr 2014 14:23:12 GMT

You are doing correct if you make it read only then user not able to select any thing on the chart.

Thanks & Regards

Re: Lock Pivot table

alexandros17 — Tue, 01 Apr 2014 14:24:52 GMT

I think you have to check both the boxes ...

Re: Lock Pivot table

Tue, 01 Apr 2014 14:36:37 GMT

If I check both boxes then the inputSUM column is not working...

The best case is user can edit data at inputSUM column, but the default filter feature in table is "de-activated".

So that user wont accidentally filter when miss clicking some cells...

can we have such ideal case?

Re: Lock Pivot table

Tue, 01 Apr 2014 14:38:12 GMT

Yupe, but as mentioned, Read Only will deactivated my InputSUM column where user is not able to edit data in that column.

Re: Lock Pivot table

Tue, 01 Apr 2014 14:49:46 GMT

Can you please attach an example?

Re: Lock Pivot table

PrashantSangle — Tue, 01 Apr 2014 15:00:25 GMT

Hi,

Use Text Object.

Cover All the fields that you do not want to select by the user.

Make it transparent .

Regards,

Re: Lock Pivot table

its_anandrjs — Tue, 01 Apr 2014 15:02:01 GMT

Use SET analysis in your Expression and Baypass the filters that you dont want user to select and chart will filter like

Count({<Channel=,Event=,UserID= >} UserID)

In this user not select Channel, Event and UserID

and use your inputSUM field as a Inputfield.

But after this you need table box

Hope this helps