topic Ignore Dimension Selections in table in App Development

Ignore Dimension Selections in table

satishkurra — Mon, 11 Nov 2024 22:24:03 GMT

Hi All

I'm having trouble with ignoring the selections in dimensions. Attached is the qvf.

On selection of country, the values of 1st quartile, median and 3rd quartile is working. But on selection of SalesPerson or Outliers (IQR) the values are recalculating. In this case even if I select Outliers (IQR) selected, I want to show the 1st quartile, median and 3rd quartile only by Country and not by Outliers (IQR) or SalesPerson.

Outliers (IQR) is a calculated dimension and the values I want to keep it constant by Country is 1st quartile, median and 3rd quartile

Can someone help me with this?

Thanks

Satish

Re: Ignore Dimension Selections in table

satishkurra — Tue, 12 Nov 2024 00:42:57 GMT

Adding expressions to make it easier to respond.

Measure: Sum(Sales)

1st Quartile: Fractile( total <[Country]> Aggr( Sum(Sales), [Country], [SalesPerson] ) ,0.25 )

Master Dimension

Outliers (IQR): =
aggr({<SalesPerson=>}
pick(
match(
(Sum(Sales) > Fractile( total <[Country]> Aggr( Sum(Sales), [Country], [SalesPerson] ) ,0.75 )) & 'a' & (Sum(Sales) < Fractile( total <[Country]> Aggr( Sum(Sales), [Country], [SalesPerson] ) ,0.25 ))
,'0a0','-1a0','0a-1','-1a-1')
,'Within Box','Highliers','Lowliers','Error in Calculation')
, SalesPerson)

Now with selecting the value from Outliers (IQR), the 1st Fractile value should not change and calculate w.r.t Country