Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Der_Unbekante_234
Contributor II
Contributor II

Vizlib Pivot hiding columns

Hello everyone,

currently I'm working on a Dashboard via Qlik Sense and created a vizlib pivot table. 

 

What I try or want to do:

1.) I want to display only the three relevant certification types (DIN EN 15085, AS9100C, IRIS) and not all 100 certificates. I want to hide the other certifications. 

 

I tried to sort the relevant certificates, so that I can see them at the first row (seems to work not right):

=match(CERTIFICATION_NAME, 'IRIS', 'DIN EN 15085', 'AS9100C', 0)

Der_Unbekante_234_0-1626900968016.png

2.) I want to make the expiry date like the traffic light systems with green (Expiry date is still valid), orange (expires soon), red (is already expired) color --> See the screenshot. Where the '-' is standing is the date. 

 

I would be happy to receive any help. I already searched on youtube, google and here in the forum for some solutions without any success.

 

Thanks in advance and Best wishes

1 Reply
NitinK7
Specialist
Specialist

for the first point may be try below

pick(match(CERTIFICATION_NAME, 'IRIS', 'DIN EN 15085', 'AS9100C'),'IRIS', 'DIN EN 15085', 'AS9100C')

second point I can't understood clearly