Read-only column in Straight Table

[Anonymous]

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

[Gysbert_Wassenaar]

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

[jagan · Accepted solution]

Hi,

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

Regards,

Jagan.

[Anonymous]

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

[#5]

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

[jagan]

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.