topic Re: Masking or blinding dimension names in QlikView

Masking or blinding dimension names

Mon, 31 Jul 2017 21:17:01 GMT

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!

Re: Masking or blinding dimension names

Mon, 31 Jul 2017 21:34:42 GMT

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.

Re: Masking or blinding dimension names

rwunderlich — Mon, 31 Jul 2017 22:17:07 GMT

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

Re: Masking or blinding dimension names

Tue, 01 Aug 2017 12:33:42 GMT

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?

Re: Masking or blinding dimension names

rwunderlich — Tue, 01 Aug 2017 15:27:16 GMT

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Masking or blinding dimension names

Tue, 01 Aug 2017 15:52:33 GMT

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

Thanks,

Ryan

Re: Masking or blinding dimension names

rwunderlich — Tue, 01 Aug 2017 16:13:05 GMT

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

Re: Masking or blinding dimension names

Tue, 01 Aug 2017 17:14:00 GMT

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

Thanks,
Ryan

Re: Masking or blinding dimension names

Tue, 01 Aug 2017 17:14:39 GMT

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

Re: Masking or blinding dimension names

rwunderlich — Tue, 01 Aug 2017 17:57:40 GMT

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

Re: Masking or blinding dimension names

Tue, 01 Aug 2017 18:08:21 GMT

Excellent, Thank you! Exactly what I needed.

Re: Masking or blinding dimension names

rwunderlich — Tue, 01 Aug 2017 18:11:31 GMT

You're supposed to mark my answer "Correct", not yours

Re: Masking or blinding dimension names

Tue, 01 Aug 2017 18:38:40 GMT

Sorry about that, I corrected.

Re: Masking or blinding dimension names

Mon, 07 Aug 2017 14:40:05 GMT

I have one additional use case that I need to be able to support. I have added an additional column in my Edit Script that is ACCESSLEVEL and it will be set to either All or Limited. If it is Limited it will provide the masking logic that you previously provided, but if it is all then I want all of the actual named DEPTs to be shown and not masked. I added the following logic, but it did not work.

=PICK(MATCH(ACCESSLEVEL,

'All' // When a user signs in with this as their ACCESSLEVEL I want the DEPT dimension to show w/o masking

,'Limited') // This works as you defined

,DEPT

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

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

'Dept' & FieldIndex('DEPT', only({<DEPT=, USERID=>}DEPT))))

, DEPT)

)

What am I missing?

Re: Masking or blinding dimension names

Mon, 07 Aug 2017 21:56:13 GMT

=PICK(MATCH(ACCESSLEVEL,

'All' // When a user signs in with this as their ACCESSLEVEL I want the DEPT dimension to show w/o masking

,'Limited') // This works as you defined

,DEPT

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

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

'Dept' & FieldIndex('DEPT', only({<DEPT=, USERID=>}DEPT))))

, DEPT)

)

What am I missing?

Re: Masking or blinding dimension names

rwunderlich — Tue, 15 Aug 2017 10:09:44 GMT

Try:

=PICK(MATCH(ACCESSLEVEL,

'All' // When a user signs in with this as their ACCESSLEVEL I want the DEPT dimension to show w/o masking

,'Limited') // This works as you defined

,aggr(only(DEPT), DEPT)

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

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

'Dept' & FieldIndex('DEPT', only({<DEPT=, USERID=>}DEPT))))

, DEPT)

)

Re: Masking or blinding dimension names

Tue, 15 Aug 2017 13:37:23 GMT

I incorporated this change in the dimension, but is still not unmasking the names.

Re: Masking or blinding dimension names

rwunderlich — Tue, 15 Aug 2017 22:03:08 GMT

I suggest debugging the thing as an expression, testing it piece by piece. For example,

if(ACCESSLEVEL='All', 'Yes, 'no')

etc.

-Rob

Re: Masking or blinding dimension names

Wed, 16 Aug 2017 20:26:56 GMT

Thanks I will try that.

Re: Masking or blinding dimension names

markagoodger — Thu, 27 Dec 2018 16:28:22 GMT

I just used your expression to achieve the same type of chart. Thank you Rob, very helpful.