Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
MrBosch
Creator
Creator

Conditional Background color in Pivot on expression to check if file exists

Hi

I am trying to create a pivot table that will show if a persons file is complete. It is complete if five images are available online.

It is working. The person and five online images are shown in my pivot table: you can see rows with and without these images (so some are complete others are still not):

MrBosch_1-1667101472755.png

What should I do to replace these images by a solid green background if they are found?

The expressions are built like:

='https://www.demo.org/uploads/'&code&'_image1.png'

So attempts to enter a condition in the expressions background, like:

=IF Len(FileSize('https://www.demo.org/uploads/'&code&'_image1.png')>0,Green() 

doesn't go well...

Labels (1)
0 Replies