topic Re: Filter the dimension value similar to explicit selection in a filter in App Development

Filter the dimension value similar to explicit selection in a filter

punitpopli — Mon, 28 Feb 2022 07:32:52 GMT

Hi All,

I am working on an issue where the dimension value had been moved from one category to another which work as expected when I select a filter explicitly. But have used a inline load to pass the filter value in an expression and the dimension value is not getting filtered out, details on the aforementioned scenario in below -

Dim1 has a value India, England, America.

Dim 2 has A, B ,C

I have a year selector (as a Inline load ) which had multiple values

Dim1 and Dim 2 are used in a Pivot table with expressions where am getting year as a filter (using inline load).

When I select Year = 2022 A was suppose to display only in India and when I select Year = 2021 "A" was suppose to display only in England.

But when am selecting 2022 using inline Year selector A is coming under both India and England. Am unable to filter value A explicitly for selected year value

Any help on this is really appreciated

Thank you in advance

-Punit

Re: Filter the dimension value similar to explicit selection in a filter

punitpopli — Mon, 28 Feb 2022 07:38:02 GMT

Adding few folks for their expert suggestion

@tresB , @jagan @marcus_sommer , @swuehl , @Clever_Anjos

Re: Filter the dimension value similar to explicit selection in a filter

tresB — Mon, 28 Feb 2022 08:01:21 GMT

Hi Punit,

It seems that your year field is in an island. And in that case, qlik would produce a cross-result for this field values when taken together with other table fields in front-end. However, what I understand is that - even in that case, you should not see A under England. So for me, I guess there is something else that is causing the issue. Try to create a sample demonstrative app and share for investigation.

Re: Filter the dimension value similar to explicit selection in a filter

marcus_sommer — Mon, 28 Feb 2022 08:17:05 GMT

Your description sound more to a missing/wrong association between your Dim1 and Dim2 - in general or maybe more specific in regard to your year-selection. If this is the case it needs to be addressed within the data-model and not with any bypass workaround in the UI.

- Marcus

Re: Filter the dimension value similar to explicit selection in a filter

punitpopli — Mon, 28 Feb 2022 12:07:26 GMT

thank you for your response.

but I cannot share the application as an attachment

Re: Filter the dimension value similar to explicit selection in a filter

punitpopli — Mon, 28 Feb 2022 12:17:00 GMT

thank you for your response.

the association in the backend is correct. But its not working as expected with the year (from island table) selected as am using the year as a filter in an expression.

When I select the year field (i.e. not from an island table) the data is getting filtered as expected, as the year selection is enforcing the data to get associate.

I cannot change anything in the data model as this might have a huge impact, hence was looking for a tactical solution to fix this.

Re: Filter the dimension value similar to explicit selection in a filter

marcus_sommer — Mon, 28 Feb 2022 12:41:27 GMT

How are both year-fields connected within the UI? I use in similar cases often a set analysis with something like this:

sum({< YEAR = p(IslandYEAR)>} VALUE)

and usually it worked well.

- Marcus

Re: Filter the dimension value similar to explicit selection in a filter

punitpopli — Mon, 28 Feb 2022 13:22:31 GMT

Yes, this is how have used it too

Re: Filter the dimension value similar to explicit selection in a filter

marcus_sommer — Mon, 28 Feb 2022 13:50:13 GMT

Maybe you could extend the logic with something like:

sum({< YEAR *= p(IslandYEAR)>} VALUE)

sum({< YEAR = p({< ... >} IslandYEAR)>} VALUE)

- Marcus

Re: Filter the dimension value similar to explicit selection in a filter

punitpopli — Mon, 28 Feb 2022 14:36:59 GMT

have already tried using P() but this is not working, meaning the selection is not getting enforced

Re: Filter the dimension value similar to explicit selection in a filter

marcus_sommer — Mon, 28 Feb 2022 15:28:34 GMT

A classical set analysis like:

{< Year = {AnyValue}>} or {< Year = p(IslandYear)>}

reflects always the availability of the selected respectively here defined values. This means it's a column-level evaluation. A comparison on a row-level is not possible in this way. In some cases you may bypass this restriction by nesting set analysis and/or combining multiple ones but the complexity will increase quite heavily and therefore it's far more common to solve such challenges rather with if-loops.

In regard to your case it's not really clear for me what didn't work like expected. Please share some screenshots of your object and the results by the various selections - and how your expected view would look like.

- Marcus

Re: Filter the dimension value similar to explicit selection in a filter

swuehl — Sat, 05 Mar 2022 10:30:01 GMT

And please also post all dimensions and expressions you are using in the chart object. It's hard to help with a lot of information missing.

Besides this, do you get aggregates (the result of your expression(s)) for the 'wrong' combination of dimensional values? Or just empty cells? In this case, also check that all expressions you are using (also for formatting) are including the set expression with your year filter.