topic Re: Force selection about dimension values based on result expression in QlikView

Force selection about dimension values based on result expression

Tue, 21 Apr 2015 12:32:24 GMT

Hello,

I need froce filter about a field (Automatically). The values that will be selected on field, would be the same values that I have in a dimension in a straight table. The dimension, only show values based on a expression result.

How can i pass or convert the values of dimensión to a selected values in a field??

Thanks!!

Re: Force selection about dimension values based on result expression

mohamed_ahid — Tue, 21 Apr 2015 13:30:30 GMT

may be a trigger can help .

can you post a sample file ?

Re: Force selection about dimension values based on result expression

satishkurra — Tue, 21 Apr 2015 13:34:41 GMT

Go the sheet properties --> Triggers tab, click add action and select Action type as Select in Field, provide field and name.

Thanks

Re: Force selection about dimension values based on result expression

Anonymous — Tue, 21 Apr 2015 13:34:48 GMT

Yes, trigger can help. It will be action "select in field". The question is about "search string" of the action. It has to select the values per table rules, which we don't know.