
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Image based on IF
In my Qlik Sense app, I am using "Media box" and an IF formula to display an image from my Image Library. If "Components" is selected the image displayed is gears, if "Engines" is selected the image is an Engine....and so on...
Here's what I have written so far:
if([DIVISION]='Components', 'https://www.website.com/appcontent/gears.png',
if([DIVISION]='Engines', 'https://www.website.com/appcontent/ENGINE.jpg',
if([DIVISION]='Fixed Wing', 'https://www.website.com/appcontent/FIXEDWING.png',
if([DIVISION]='Industrial Processes', 'https://www.website.com/appcontent/industrialprocesses.jpg',
if([DIVISION]='Rotary Wing', 'https://www.website.com/appcontent/ROTARYWING.png','' ))))) as [IMAGE]
What I am trying to do is add an additional image(representing "ALL") to my Image Library and have a Formula that requests that image if Components, Engines, Fixed Wing, Industrial Processes, and Rotary Wing are ALL SELECTED.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I walked away, grabbed a coffee, and came back to try again. This worked! Much appreciated!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Keitheric,
You can use GetSelectedCount() and see if all are selected. If this is the case, point towards the 'ALL' image.
Jordy
Climber

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Jordy,
But, no luck. When I try to add GetSelectedCount() to my formula in the Data Load Editor, it doesn't work (or even identify GetSelectCount as a command).
for individual selections, this works, and looks good. But to finish this off, I really need to get the "All" divisions to populate an image 😞

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ah, I thought you were doing this in the front-end... GetSelectedCount() isn't going to work in the back-end.
Could you maybe show an image of what you want to achieve?
Jordy
Climber

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to get the "All" image to populate when all of the DIVISIONS are selected.
This is my data load editor screen as well as what I see when I select each DIVISION.
I created an image meaning "all", and I have tried to determine a solution to get it to display "All" when all of the DIVISIONS are selected, but no luck. Any help would be appreciated.
My images are in my Image Library, and i copied the link to the file.
I'm using Media Box extension.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think this is going to work this way. You will need to create another image, that contains all these images in one image.
Then in the front-end you need to create a formula that says:
IF( GetSelectedCount( Division ) = 6 ,
TotalImage,
Image
)
Jordy
Climber

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Below is an image of Media Box. If I change the front end to the formula from your last post, I will lose the link to my other 5 images. (=IMAGES).
If you can think of a different way for me to accomplish this, i will change course! Open to suggestions!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I walked away, grabbed a coffee, and came back to try again. This worked! Much appreciated!
