Set Analysis in Dimension

[brunopaulo]

Hello Community,

I am trying to solve a small problem in my qvw, at the moment I have 1 dimension with the name BusinessUnit where I have 3 categories (Analyzes1, Analyzes2, Analyzes3) within each of these analyzes I have several offices. On my dashboard I am doing a detailed analysis of each of the categories. To do this, I want to compare several factors within each of the categories. Therefore, I need my dimension to be BusinessUnit and show in a table the offices of Analysis1, in another table show the offices of Analysis2, etc. Without have a column with name BusinessUnit and disregarding user select on other sheets.

Can someone help?

Thank you in advance
Regards

Bruno Paulo

[prat1507]

Hi Bruno

Couldn't get exactly what do you need, especially this line:

Without have a column with name BusinessUnit and disregarding user select on other sheets.

Regards

Pratyush

[jelle_vervloess1]

Hi Bruno

Dimensions listen to their respective measure, so if you only want rows displaying data of analysis 1 you would need to create the measures with a set expression that looks like this {1<businessUnit = {"analyzes1'}>}.

the 1 in this set expressions tells the set to igonore the selected set of the user.

if this is not what you are looking for can you please elaborate i will try and help

[techvarun]

Use below script as Dimention

=If (Categories = 'Analyzes1', Categories) and check suppress the value is null check-box

[brunopaulo]

exactly this, Thank you

[brunopaulo]

This is helpfull too Thank you

[brunopaulo]

Already anwnsered below