topic Re: Restrict selection in Tablebox in QlikView

Restrict selection in Tablebox

Anonymous — Mon, 28 Oct 2013 17:10:42 GMT

Hi,

I have filters for selections, so, I dont need any selections anywhere else... On Charts, I can avoid selection by read only option but Is there any way to avoid selection on Table box?

Re: Restrict selection in Tablebox

venkatg6759 — Mon, 28 Oct 2013 17:18:27 GMT

Use alternate states in QV 11.

Re: Restrict selection in Tablebox

Anonymous — Mon, 28 Oct 2013 17:27:02 GMT

I can see data in table box,chart w.r.t filters selections but i want to restrict selections for user in TABLE BOX & Chart , In chart I can do it by read only option- but How can I do it in table Box?

Re: Restrict selection in Tablebox

sasikanth — Mon, 28 Oct 2013 17:27:53 GMT

HI Praveena

There no specific Property to avoid selection in table box i think

But You can Use calculation condition in General properties ...so that you can

Regards

Sasi

Re: Restrict selection in Tablebox

CELAMBARASAN — Mon, 28 Oct 2013 18:22:09 GMT

Hi,

Better use Straight table with 1 in expression and hide the expression column.

You could possibly think of placing the Text box with transparent background over the table box. It protects selection on the table box.

Re: Restrict selection in Tablebox

Anonymous — Mon, 28 Oct 2013 19:16:25 GMT

Thanks Celambarasan

Also to avoid user modifying width of a column in any table like pivot/straight table, is it only way to mask it in transparency?

Re: Restrict selection in Tablebox

CELAMBARASAN — Mon, 28 Oct 2013 19:19:41 GMT

For that Go to sheet properties --> Security-->uncheck the Move/Size Sheet Objects

Re: Restrict selection in Tablebox

Anonymous — Mon, 28 Oct 2013 19:27:26 GMT

I mean avoiding sizing of columns, not the object size..

Re: Restrict selection in Tablebox

CELAMBARASAN — Mon, 28 Oct 2013 19:38:53 GMT

You mean that object should be able to resize?

Re: Restrict selection in Tablebox

Anonymous — Mon, 28 Oct 2013 19:51:03 GMT

We can restrict size of the object in a sheet by the way you said before, or by individual object properties, I want to restrict user to not yo change columns width..

for example in sample below.,

I want to restrict user to avoid width of columns 2012 Q1, 2012 Q2 etc.,

Re: Restrict selection in Tablebox

CELAMBARASAN — Mon, 28 Oct 2013 20:00:45 GMT

I think you should uncheck all the option in the sheet Properties under security tab.