topic Re: Making one dimension read only in QlikView

Making one dimension read only

Mon, 25 Nov 2013 19:35:58 GMT

I have two dimension in a bar chart. I want to make one dimension read only. Can i do that ?

Josh_Good — Mon, 25 Nov 2013 21:02:45 GMT

What do you mean by "ready only"?

marcohadiyanto — Tue, 26 Nov 2013 06:23:00 GMT

Hi Sumit

maybe its a little bit tricky,

you can use set analysis in your expression.

ex. sum( {$<Dimension1 = >} Sales)

here the example from help

sum( {$<Region = >} Sales )
returns the sales for the current selection, but with the selection in “Region” removed.

so when we do selection on dimension1, dimension1 not change because when we add set analysis the selection dimension1 removed.

Regards

Anonymous — Tue, 26 Nov 2013 20:35:04 GMT

Sumit

Do you mean you want to lock it ? As in stop people changing which dimension value is selected.

Best Regards, Bill

vikasmahajan — Wed, 27 Nov 2013 06:18:16 GMT

User Wise Section Access you can apply and base on some variable you can achieve the same.

Vikas