topic Re: Data Association Dismisses Non-associated Entries in App Development

Data Association Dismisses Non-associated Entries

AK13 — Sat, 16 Nov 2024 02:02:28 GMT

Hi Everyone,

After creating a data association between two tables, I noticed that rows that were not associated are not included in calculations (sum, count, etc.) done in my Qlik application.

I am trying to sum a sales value, and it needs to include the entire dollar value regardless of whether the association with the other table exists or not. How can I do this?

Thanks

Re: Data Association Dismisses Non-associated Entries

Lisa_P — Mon, 29 Jun 2020 04:28:23 GMT

For the total Sales values, you can use the TOTAL qualifier to ignore dimensions. Also you can use the {1} in set analysis to ignore selections.

eg Sum({1} TOTAL Sales)

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/define-aggregation-scope.htm

Re: Data Association Dismisses Non-associated Entries

AK13 — Mon, 29 Jun 2020 04:44:54 GMT

Hi Lisa,
Thank you for your reply. I am not trying to ignore any dimensions or selections.
The issue is that not all the data in my sales table is available for aggregation after I associate it with my other table. Only rows with associations found pass through for me to aggregate.
I still want to be able to filter my data accordingly, but I want my sum to include the dollar value for products sold even if there is not reference to them in the other table.
Thanks

Re: Data Association Dismisses Non-associated Entries

Lisa_P — Mon, 29 Jun 2020 04:47:35 GMT

This sounds like a data model issue.

Re: Data Association Dismisses Non-associated Entries

tresB — Mon, 29 Jun 2020 05:45:47 GMT

If you are using a field from one table as dimension in a chart and one field from another table in expression/measure, you might notice such issue. We could think of a possible solution here. However, it would be helpful for us here to help you if you could explain the issue and expected output with a sample app.