Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

educastri83
Contributor

Help with Segregation of Duties Matrix and hide columns

Hello community!

This time I am working in a matrix of segregation of duties.

I added the matrix model to a dashboard in Qlikview, but I can not interact as I would like when I select some dimensions ... for example, it shows all the expression columns and should not appear when the group does not exist in the "Role" dimension "selected, at the same time that I would like to be able to build high, medium or low incompatibility KPIs.

Dashboard.png

I have these challenges:

1) I need to be able to calculate some KPI's for each group: the high, medium and low incompatibility risks.

2) Hide columns of the expressions, showing only those groups that exist when they select some value of the dimensions such as "role", and "user". Something like this:

Desired result hide - columns.png

To calculate the KPI of high risk incompatibilities, i'd created a variable named "vHighRisk" with the following calculation:

SUM (Aggr (if (sum ([Vendors Master]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Purchase Order Entry]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Physical Inventory]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Sales Agrmts / Contracts]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Customer Master Maint.]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Sales Invoicing]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Sales Invoice Release]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Sales Order Entry]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Sales Order Release]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Sales Pricing Maint.]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Maintain Security]) = 3,1,0), Group))
+ SUM (Aggr (if (sum (Payments) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Bank Reconciliation]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Cash Application]) = 3,1,0), Group))
+ SUM (Aggr (if (sum ([Search Operations]) = 3,1,0), Group))

The above works well if it stays static, but when selecting some other dimension the result is not updated, it is not the desired result, I would like to get a better practice

Thank you all

1 Solution

Accepted Solutions
Digital Support
Digital Support

Re: Help with Segregation of Duties Matrix and hide columns

Best I have is search around on the Design Blog area, hopefully you can find something that may be helpful there, sorry I am not more help, but my dev skills are not what you want helping you! 🙂

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

1 Reply
Digital Support
Digital Support

Re: Help with Segregation of Duties Matrix and hide columns

Best I have is search around on the Design Blog area, hopefully you can find something that may be helpful there, sorry I am not more help, but my dev skills are not what you want helping you! 🙂

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post