Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Not applicable

create quality check using a traffic light gauge

Hello community,

I want to create a quality check using a traffic light gauge but I don't know how to write the syntax.

Each Department has to submit a report each week - so I want to display green for all departments that have submitted reports for all availabe weeks and red if one week is missing.

Fields:

CalendarWeek

Department

The Output should be a straight table which lists all Departments with a red or green traffic light next to it, depending on the result.

How do I have to construct the expression? Do I need a set analysis for it?

Thank you.

1 Solution

Accepted Solutions
Luminary
Luminary

Re: create quality check using a traffic light gauge

Hi, is this what you need?

3 Replies
Luminary
Luminary

Re: create quality check using a traffic light gauge

Hi, is this what you need?

Not applicable

Re: create quality check using a traffic light gauge

Perfect! Thank you very much.

Not applicable

Re: create quality check using a traffic light gauge

Out of curiosity. What if I wanted to calculate the traffic light based on two dimensions?

For example: Department_DB and Department_Excel. This is used to check whether the entry for a department in Excel is the same as the Department_DB.

Since mismatches can occur here for example "DepA" in Excel is assigned to "DepB" in the DB for a certain calendar week, how can one set the traffic light so that both dimensions are checked for the week field and result in TRUE if both equal to true?

Department_ExcelDepartment_DBWeek
DepADepA31
DepADepB32