topic Re: Ignore selection in dimension in App Development

Ignore selection in dimension

callmedaddy — Tue, 14 Apr 2020 14:26:16 GMT

Hello,

I'm having this issue. I have a filter like that:

=Aggr(Only({<Company = {'X'}>} Product),Product, Category)

for showing only the products sold by company X, which selects both the product name and the category as filters.

I also have a table with a single column: Company - in which I want to display all the companies that have products in that category selected previously (so basically, I need to ignore the Product selection). I tried:

=Aggr(Only({< Product = >} Company),Company) - but with no succes. It only shows company X.

Can you please help me with that?

Thanks!

Re: Ignore selection in dimension

lorenzoconforti — Tue, 14 Apr 2020 15:33:52 GMT

Try using the set analysis in your measure in the table, not the dimension

Re: Ignore selection in dimension

callmedaddy — Tue, 14 Apr 2020 15:53:46 GMT

ONE MORE THING:

In script I generated RGB codes for each Company. The table I am talking about (it only has a column - Company) works as a "Legend" for another chart. I wanted to apply the background color of the field in the table as the color assigned in script, that's why I don't have any measure.

Any idea how to solve that?

Re: Ignore selection in dimension

lorenzoconforti — Tue, 14 Apr 2020 16:15:07 GMT

Not sure how you would be able to achieve it with just one column. The only advice I have is to include a second column anyway in which you can give some relevant information (like a count)