GetSelectedCount() for master dimension

mrbalyaqv — Sat, 16 Nov 2024 05:31:55 GMT

Hi all!

I'm trying to achieve following:
- before any selection made, in table there's no fields shown, only totals for measures;
- when user selects some fields from a list, these fields would be displayed in table.
When I use a data field for this 'fields list' all works just fine, but on selection bar real field name is displayed:

I'd want change displayed fields name on selection bar, because the real name could have a realy 'ugly' and not user-friendly name. For this purpose I created a master dimension. And now after selection from this dimension I see its name on selection bar, but displaying of selected columns doesn't work:

I guess, this happens because after selection in master dimension QS makes not same selection in initial field. If I understand correctly, GetSelectedCount() works only for expressions, that reurn field.

I thought about using GetPossibleCount() instead, but I don't know how to determine if it 0 or all values are selected in master dimension.

So, my question is: is it even possible to make selection in master dimenssion and count number of selected values?

Sample qvf-file attached.

Re: GetSelectedCount() for master dimension

sunny_talwar — Thu, 20 Jun 2019 14:43:50 GMT

This is not perfect, but you can try this

=Count(DISTINCT [_f_pivot_dim]) > 0 and SubStringCount(Concat(_f_pivot_dim, '|'), 'Name') > 0

When nothing is selected, this will show all three dimensions.

Re: GetSelectedCount() for master dimension

mrbalyaqv — Mon, 24 Jun 2019 10:23:12 GMT

Well, it's not exactly what I tried to do, but I can deal with it. Thank you!

topic Re: GetSelectedCount() for master dimension in App Development

GetSelectedCount() for master dimension

Re: GetSelectedCount() for master dimension

Re: GetSelectedCount() for master dimension