Masking or blinding dimension names

[#1]

Hello,

I am developing an application and need the ability to mask or blind the dimension names for all dimension names with the exception of the dimension value selected.  In my use case below I have a bar chart with a dimension called Department with the following dimension values (Finance, IT, Customer Service, Shipping).  I then select the Finance Department and I would like the bar chart to show Finance as it is the value selected, but would then like to mask the other three departments to show as Dept 1, Dept 2 and Dept 3.

I have tried to add a calculated dimension, but it does not provide the result I am looking for.  Below is an example of what I am trying to achieve. 

Can someone provide a solution to my problem?

Thanks!

[#2]

One thing I failed to mention is that the dimension will be dynamic with changing departments and close to 100 different values at any given time.

[rwunderlich]

See the attached qvf for an example of what you are asking using the "CategoryName" field.

Dimension:

=aggr(

if(len(only({<CategoryName=>}CategoryName))> 0

,if(only({<CategoryName=>}CategoryName)=Only(CategoryName)

,CategoryName

,'Cat' & FieldIndex('CategoryName', only({<CategoryName=>}CategoryName))

))

, CategoryName)

Measure:

Sum({<CategoryName=>}Sales)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#4]

I applied the logic you provided, but now all that I receive in the bar chart object is just the selected dimension.  Do you happen to have a qvw example so I can reference?

[rwunderlich]

Here's a QVW example. If you can't get it working, please post a sample qvw.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#6]

Hi Rob, I do not see the attached sample qvw?

Thanks,

Ryan

[rwunderlich]

I can see the qvw as an attachment to my previous reply. Not sure why you can't see it, maybe it's going through moderation or something. Can you post an example qvw showing the problem you are having?

-Rob

[#8]

Here is an example of my QVW that I am still having issues with.

Thanks,
Ryan

[#9]

There is section access and can enter Ryan in the popup box

[rwunderlich · Accepted solution]

You are selecting and locking the USERID, which is linked to DEPT, so USERID has to be modified in the Dimension:

=aggr(

if(len(only({<DEPT=, USERID=>}DEPT))> 0

,if(only({<DEPT=, USERID=>}DEPT)=Only(DEPT)

,DEPT

, only({1}DeptMasked)

))

, DEPT)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com