topic Re: calculation condition with getselectedcount () in App Development

calculation condition with getselectedcount ()

tobiasaechter — Fri, 05 Jan 2024 16:19:19 GMT

Hi,

I have a table which I would like to conditionally show/hide depending on the users selection in a list box.

I have tried using the calculation condition with various approaches:

- "getSelectedCount(Field)>0" -> the table is always hidden, independently on any selection in "Field"

- "Count(Field)>0" -> the table does not hide at all.

Can anyone help me understanding what I am doing wrong?

Thanks

Re: calculation condition with getselectedcount ()

MatheusC — Fri, 05 Jan 2024 16:34:24 GMT

@tobiasaechter

Hi,
are you inserting double quotes ""?
if it is removed from the expression.

GetSelectedCount(Field)>0

Att, Matheus

Re: calculation condition with getselectedcount ()

tobiasaechter — Fri, 05 Jan 2024 17:12:26 GMT

No I didn’t use double quotes. Just this: getSelectedCount(Field)>0

I only used the double quotes here in the question.

Re: calculation condition with getselectedcount ()

MatheusC — Fri, 05 Jan 2024 18:08:03 GMT

@tobiasaechter

According to what you said, I don't see any error in the expression, remembering that:

Hiding graphs using a condition inserted in the Add-ons -> Data handling -> Calculation condition.

Getselectcount() will return the current number of selected values in the field.

Review the information, if you are unable to resolve the issue, provide more details on the matter.

Att, Matheus

Re: calculation condition with getselectedcount ()

tobiasaechter — Fri, 05 Jan 2024 18:21:10 GMT

Well yes I understand that Getselectcount() will return the current number of selected values in the field.

hence I am not totally sure if this is the correct expression to begin with. That is why I tried the count() as well.

happy to learn if you have any suggestion for a better expression to use here.

Re: calculation condition with getselectedcount ()

MatheusC — Fri, 05 Jan 2024 20:51:46 GMT

@tobiasaechter
maybe this:

GetCurrentSelections()) for the selections in a string, len for the number of characters
len(GetCurrentSelections())>0
or
 Len(Trim(GetCurrentSelections()) > 0)

greetings

Re: calculation condition with getselectedcount ()

tobiasaechter — Sat, 06 Jan 2024 09:52:55 GMT

len(GetCurrentSelections())>0

this does work, thanks, but can I also specify one specific field in the brackets?

like: len(GetCurrentSelections(Field1))>0 ?

I have tried this but it seems even if I add a specific field (Field1), the table still shows/hides as soon as I do a selection in any of the fields in my data model.

Ideally I would like to achieve the following:

(len(GetCurrentSelections(Field1))>0 and len(GetCurrentSelections(Field2)) = 'X') or len(GetCurrentSelections(Field3))>0

is this even possible?

Re: calculation condition with getselectedcount ()

vinieme12 — Mon, 08 Jan 2024 02:51:37 GMT

Just the below is sufficient for a calculation condition

=getSelectedCount(Field)

However can I ask what do you mean by Show / Hide? are you trying to completely hide the chart object? calculation condition is only meant for enable/disable chart evaluation not show/hide chart object !

the table is always hidden, independently on any selection in "Field" << is the "Field" in an alternate state??

if yes then you need to specify the statename in

=getselectedcount(Field,False(),'statename')

Re: calculation condition with getselectedcount ()

tobiasaechter — Mon, 08 Jan 2024 07:28:12 GMT

sorry for not being clear. I meant show/hide the values in the table. I understand that calculation condition does not make the whole table disappear, but rather disables/enables the values shown/calculated in the table.
This is exactly what I would like to achieve.

If there is no selection the table should show a message like "please select at least one value in Field 1 and 2 or field 3". In case of any selection in these specified fields the table should show/calculate the data.

I am not using any alternate states.
=GetSelectedCount(Field) did not seem to work at all though. With this expression the table never calculates the data but always shows the message that the calculation condition is not fulfilled.

Whereas len(GetCurrentSelections(Field1))>0 seems to work, but I cannot specify any field so far. It rather disables/enables the chart evaluation for any selection in any field.

Re: calculation condition with getselectedcount ()

marcus_sommer — Mon, 08 Jan 2024 09:11:42 GMT

Make sure that you are calling the right field with the correct typing and not referring to a label for a field or to a calculated dimension.

Re: calculation condition with getselectedcount ()

tobiasaechter — Mon, 08 Jan 2024 10:09:00 GMT

in a simplified setup I have four fields: Country, Business, Year, Order Volume
My table has country and business as dimension and SUM(Orders) as measure.
the calculation condition is: len(GetCurrentSelections(Business))>0

I would have expected that if any value in the field business is selected the table should show/calculate the data. whereas any selection in country or year would not have any influence on the calculation condition.

but the actual behaviour is that any selection in business, country or year does trigger the calculation condition.

Re: calculation condition with getselectedcount ()

marcus_sommer — Mon, 08 Jan 2024 10:41:15 GMT

The proper way is: getselectedcount(TheRightField). Nearby would be: len(getfieldselections(TheRightField)) by adding an extra layer. Instead of this would be getcurrentselections() in general also be usable but with a lot of extra efforts to extract the relevant information.

Like above mentioned take a closer look on the real field-names which may differ to the ones which are shown - maybe any qualifying-information is removed or something similar ...

Further make sure that all relevant objects are within the same selection-state (if any alternate states are applied).

Re: calculation condition with getselectedcount ()

tobiasaechter — Mon, 08 Jan 2024 11:12:16 GMT

I think I have figured out the issue.

using getselectedcount(Field) works, but the issue was that I had pre-filtered my field in the filter pane's dimension.
like my Field has values 1,2,3,4,5 and in my filter pane I had used "if(not match(Field, '3'), Field)" because I did not want the user to be able to select the value 3 in this field.
If I then tried to select in this filter pane the chart did not react. But if I am not pre-filtering the field the calculation condition works like expected.

Re: calculation condition with getselectedcount ()

vinieme12 — Mon, 08 Jan 2024 12:42:07 GMT

I'd second what @marcus_sommer has suggested

Add the following expression in a textbox and make sure the count is updating when you make selections

=GetSelectedCount(Field)

If the numbers don't change as you select values in that field there are only 2 possible reasons

1) alternate states in play

2) wrong field being referred Field and field are two different fields as field names are case sensitive

Re: calculation condition with getselectedcount ()

tobiasaechter — Mon, 08 Jan 2024 13:54:53 GMT

is it possible that Qlik thinks the field name changes if I have a list box where the dimension is "Field" vs "=if(not match(Field, 3), Field)"
I would have assumed the field name is the same in both cases. But this is where the issue was coming from.

Re: calculation condition with getselectedcount ()

marcus_sommer — Mon, 08 Jan 2024 14:10:58 GMT

It's not a native field anymore else a calculated dimension. In general such approaches should be rather avoided because it didn't only effects selections else prevents the usage of aggr() and/or TOTAL statements and impact the performance.

In your case it would be probably better to double the field within the data-model - ones complete for admin and power users and the second one with a NULL() replacement for the unwanted values. If there are various value-combinations and/or fields to consider it would hint for the usage of section access to implement a real access control on a user-level.