Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Control which dimensions the user can select

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?

Tags (1)
5 Replies
israrkhan
Valued Contributor II

Re: Control which dimensions the user can select

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...

mov
Esteemed Contributor III

Re: Control which dimensions the user can select

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

Not applicable

Re: Control which dimensions the user can select

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

Highlighted
mov
Esteemed Contributor III

Re: Control which dimensions the user can select

"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

Not applicable

Re: Control which dimensions the user can select

OK, thanks

Community Browser