topic Re: Control which dimensions the user can select in QlikView

Control which dimensions the user can select

Thu, 24 Oct 2013 16:30:20 GMT

I would like to constrain which dimensions the user can select. I can (sometimes) get a list box to make it so a dimension has 'always one selected value'. But I would have one pivot table (based on dimensions not used anywhere else) that I would like not to let the user click on and reduce. Any ideas how this is possible?

Re: Control which dimensions the user can select

israrkhan — Thu, 24 Oct 2013 16:40:22 GMT

use set analysis for those dimensions in pivot table, in your expressions,

let say you have expression =sum(sales) and dimension Year, Quarter, Month.

so use expression as =sum({< Year= , Quarter= >}sales).

now if user will make selection in Year or Quarter, then in the pivot table there will be no change...

so you can fix your dimension in expression...

hope it helps...

Re: Control which dimensions the user can select

Anonymous — Thu, 24 Oct 2013 17:11:37 GMT

Daniel,

Maybe you can set your pivot table properties to "Read Only". In this case the table will react on selections made anywhere, but not allow to click on the table itself. Obviously this solution is not usable if you want to allow to click on some dimensions.

Regards,

Michael

Re: Control which dimensions the user can select

Fri, 25 Oct 2013 09:02:45 GMT

Great, this works for my purposes- thanks, I hadn't experimented with that check box before!

While I'm asking questions - is there a way to constrain selections so that at most one value can be selected in a dimension? I can use list boxes so that always one is selected, but that's not quite the same...

Thanks,

Daniel

Re: Control which dimensions the user can select

Anonymous — Fri, 25 Oct 2013 10:22:00 GMT

"At most one" - do you mean that it is allowed to clear all or select one, but not allowed to select more than one?

There is no such property. It is possible to do it using a macro which will be triggered on select in the field, will check how many selected, and if more than one - clear the field and produce a message.
If you're going to use your application in AJAX, you better avoid using macros.

Regards,

Michael

Re: Control which dimensions the user can select

Fri, 25 Oct 2013 15:36:26 GMT

OK, thanks