topic Help in set analysis in App Development

Help in set analysis

Neha121 — Thu, 16 Oct 2025 05:22:14 GMT

Hi All,

I have below data model filter on screen and a bar chart. My bar chart filters perfextly for FY year as its key in both tables. I want my bar chart to Filter when "Company" is selected. sum({< Company_MF = Company>}Total Value).. whats the right way of doing it.

Data Model

These are the filters on sheet

Filter

FY Year

Company

Department

I have created the bar char with these fields

Bar chart

Gender_MF

sum(Total Value)

Re: Help in set analysis

PrashantSangle — Thu, 16 Oct 2025 05:37:12 GMT

Do you need this for just one object or all dashboard??

if for all dashboard then create Composite Key in your data model

in table 1

FY_Year&'_'&Company as key

in table 2

FY_Year&'_'&Company_MF as key

Regards,

Re: Help in set analysis

Vegar — Thu, 16 Oct 2025 05:46:03 GMT

You might be able to solve this using set modifier with set functions. Try this expression.

sum({< Company_MF = P(Company)>}Total Value)

Re: Help in set analysis

Amit_Prajapati — Thu, 16 Oct 2025 05:45:05 GMT

Hi @Neha121 ,

If you'd like the chart to display data only after a company is selected from the filter, you can use the following expression under Add-ons → Data Handling in the Calculation Condition field:

GetSelectedCount(Company) > 0

This ensures the chart remains hidden until at least one company is selected.

let me know if you need anything else or if your requirement is different.

Re: Help in set analysis

marcus_sommer — Thu, 16 Oct 2025 09:47:55 GMT

IMO the data-model isn't suitable. Instead of keeping two fact-tables it would be better to concatenate them by harmonizing all field-names and data-structures as much as possible and adding an extra source-field which enables the possibility to differentiate between the sources in dimensions/selections/conditions.