topic Re: Read-only column in Straight Table in QlikView

Read-only column in Straight Table

Anonymous — Tue, 02 Jul 2013 16:56:00 GMT

I was wondering if there is an elegant solutions (a macro probably) to make some columns in a straight table read-only.
Basically what I am trying to achieve is to give the user the possibility to select the values in some of the columns but not in all of them.
At the moment I am sticking a transparent textbox on top of the columns that I want to be read-only.
Setting the read-only flag for the entire table would be too restrictive. Any suggestions?
Thank you

Re: Read-only column in Straight Table

Gysbert_Wassenaar — Tue, 02 Jul 2013 17:32:41 GMT

The way you're using transparent textboxes is the only way to do this afaik.

Re: Read-only column in Straight Table

jagan — Tue, 02 Jul 2013 17:37:17 GMT

Hi,

Please find attached file, hope this is what you are expecting.

Regards,

Jagan.

Re: Read-only column in Straight Table

Anonymous — Wed, 03 Jul 2013 07:59:04 GMT

Thank you Jagan and Gysbert.

Jagan, thank you, in my specific case your solution works.

For QlikTech:I would really like to have more control over the properties of Straight and Pivot Tables!

Thank you

Re: Read-only column in Straight Table

Mon, 14 Jul 2014 21:22:32 GMT

I downloaded the file and its exactly what I need but i cant see how you did it. Can you please explain?

Re: Read-only column in Straight Table

jagan — Tue, 15 Jul 2014 03:40:51 GMT

Hi Jason,

In set analysis expression I excluded the selection of dimension by giving Year=,

=Sum({<Year=>}Sales)

This will ignore the selection of year, so the straight table won't affect.

Regards,

Jagan.