topic Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table in App Development

Qlik Sense: Show all dimension values in a table regardless of selected dim in table

DanaL — Thu, 06 Oct 2022 16:37:04 GMT

Hi People,

I would like to trigger a display based on a selected dim value in a table.

Actually the selection is not needed for filter, therefore I would like the dims to be displayed.

So the table "imitates" a filter object.

Adding {<Dim=>} to the table expressions didn't help.

Edit:

My table has as a dim measure names which are loaded from a floating table.

When a specific measure is selected, it is also displayed in the next bar chart.

In Qlikview you can place a transparent button on top of the table so the measure is not really selected.

I would like to imitate this functionality in Sense.

So when a measure is selected, I still want the other measure names to show in the table.

Another words, to bypass the "natural" behavior, where only the selected dim is displayed:

Thanks!

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

edwin — Thu, 06 Oct 2022 15:48:47 GMT

i am having difficulty picturing the requirement, others might have the same challenge, if you can post screenshots of what you want to happen againts what you are experiencing - that might explain the ask better

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

DanaL — Thu, 06 Oct 2022 16:37:55 GMT

Hi Edwin,

I have edited my post.

Thank you!

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

edwin — Thu, 06 Oct 2022 22:23:07 GMT

i would have asked if youve tried adding the measure field in the modifier to ignore its selection. but i think its not that simple. if you have a filter for your measure field and dont want the user to select it from the chart, you can create a duplicate field. add the duplicate field in the chart and then add the duplicate filed in the set analysis modifier to ignore it. this means if the user clicks the duplicate field in the chart, the click will be ignored

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

DanaL — Fri, 07 Oct 2022 05:08:53 GMT

Hi Edwin,

I've added a field.

After selection, the dim values are displayed as desired, but not the expressions.

I did add to them {<_Dummy=>}

My solution is to use a filter with the measure names, and one selected value.

When a measure name is selected, the corresponding name in the table is colored, and the bar chart is updated.

Thanks!

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

edwin — Fri, 07 Oct 2022 12:39:07 GMT

the duplicate field should be just that - a duplicate . this means it has to be exactly the same as your measure field - they need to have teh same value. whereever the measure field is, the duplicate should be there. for example:

where before, your load was:

load ... xxx as Measure, ...

you should add a duplicate field:

load ... xxx as Measure, xxx as Dummy, ...

so you see in the chart, it should behave exactly like your measure field. and if the user selects it, nothing will happen in the table as you are ignoring it

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

DanaL — Fri, 07 Oct 2022 15:00:03 GMT

Hi Edwin,

Thanks for your kind help.

I did as you suggested, but I get the same result:

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

edwin — Fri, 07 Oct 2022 16:28:25 GMT

this means the expression is not ignoring the selection for Dummy field, add DUmmy= to the expression set analysis

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

DanaL — Fri, 07 Oct 2022 17:48:02 GMT

Hi,

I did that, of course, but it didn't help...

Re: Qlik Sense: Show all dimension values in a table regardless of selected dim in table

edwin — Fri, 07 Oct 2022 19:32:42 GMT

this is what i am talking about, its a simplification of your problem but the idea is there:

user selects 4 out of 5 measures, the chart shows the 4 that are selected, then the user clicks 2 of the measures in the chart. the chart still shows 4 measures regardless what the user clicks on the chart. of course i changed the label for the dummy field to Measure. here is my code:

as i said, just duplicate measure