topic Re: Set Analysis in Dimension in QlikView

Set Analysis in Dimension

brunopaulo — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Analysis in Dimension

prat1507 — Wed, 04 Oct 2017 10:33:06 GMT

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

Re: Set Analysis in Dimension

jelle_vervloess1 — Wed, 04 Oct 2017 10:45:32 GMT

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

Re: Set Analysis in Dimension

techvarun — Wed, 04 Oct 2017 10:48:37 GMT

Use below script as Dimention

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

Re: Set Analysis in Dimension

brunopaulo — Wed, 04 Oct 2017 10:50:36 GMT

exactly this, Thank you

Re: Set Analysis in Dimension

brunopaulo — Wed, 04 Oct 2017 10:51:02 GMT

This is helpfull too Thank you

Re: Set Analysis in Dimension

brunopaulo — Wed, 04 Oct 2017 10:51:39 GMT

Already anwnsered below