topic Re: Change imagem - Two conditions - Textbox in QlikView

Change imagem - Two conditions - Textbox

Anonymous — Thu, 19 Apr 2018 14:55:03 GMT

Hello,

Does Anybody knows how to change imagem with two conditions in text object?

I tried 2 ways, but they don't work.

=if([project] = 'Security Operations' and [Fase 1] = 'On time', 'qmem://Img_id/green',

if([project] = 'Security Operations' and [Fase 1] = 'Late', 'qmem://Img_id/red'))

=if(([project] = 'Security Operations' and [Fase 2] = 'On time'),'qmem://Img_id/green', 'qmem://Img_id/red')

This last way, shows only the last image (red), even I change the "Fase 2" status.

Thank you for your attention.

Re: Change imagem - Two conditions - Textbox

Anil_Babu_Samineni — Thu, 19 Apr 2018 14:55:37 GMT

You should select project and Fase2 then only Green come due to AND operator. Or you can use OR operator for that.

Re: Change imagem - Two conditions - Textbox

vvira1316 — Thu, 19 Apr 2018 15:03:09 GMT

try this

=if([project] = 'Security Operations', If([Fase 1] = 'On time', 'qmem://Img_id/green', 'qmem://Img_id/red'))

Re: Change imagem - Two conditions - Textbox

Anonymous — Thu, 19 Apr 2018 16:22:53 GMT

Unfortunately, It didn't work.

Re: Change imagem - Two conditions - Textbox

Anonymous — Thu, 19 Apr 2018 16:23:00 GMT

Unfortunately, It didn't work.

Re: Change imagem - Two conditions - Textbox

vvira1316 — Thu, 19 Apr 2018 18:18:09 GMT

Would it be possible for you to share sample data and/or app file. You can mask data, refer to Preparing examples for Upload - Reduction and Data Scrambling

Re: Change imagem - Two conditions - Textbox

Anonymous — Thu, 19 Apr 2018 19:05:14 GMT

Here you go.

Thank you so much

Re: Change imagem - Two conditions - Textbox

vvira1316 — Thu, 19 Apr 2018 19:46:52 GMT

You have following script. Field names are different in script and in your question. Also looking at this data information I'm not seeing data values that will provide 'On time' and 'Late' or even Fase 2 so can you please guide here.

LOAD [Projetos Fase 1],
[Status Fase 1]
FROM
[..\plan db.xlsx]
(ooxml, embedded labels, table is [Fase1-DOD]);

Projetos Fase 1	Status Fase 1
Security Operations	Em andamento - Em dia
Rede Virtualizada	Em andamento - Atrasado

Also it would not work in the text as you have set it up.

Not sure if following is what you are expecting

=if([Projetos Fase 1] = 'Security Operations',
If([Status Fase 1] = 'Em andamento - Em dia',
'qmem://<bundled>/BuiltIn/check_g.png', 'qmem://<bundled>/BuiltIn/exclamation_r.png'),
'qmem://<bundled>/BuiltIn/check_g.png')

Re: Change imagem - Two conditions - Textbox

vvira1316 — Thu, 19 Apr 2018 20:45:10 GMT

You have data issue..

Please refer to image below.

In above case It is not Security Operations and Em andamento - Em dia so it should give you red which it is giving

I reloaded data using your sample data file and I get following.

In above case It is Security Operations and Em andamento - Em dia so it should give you green which it is giving

Also your text object will respond if you had a list box to select Status Fase 1 field values as seen in images below

Here I've used same expression that you had

Re: Change imagem - Two conditions - Textbox

Anonymous — Fri, 20 Apr 2018 11:40:37 GMT

This way, I need to select field in table to change image and its not work for me.

I need that the image change according is set in spreadsheep (db) field only.

when project load -- if the value in the field (db) is one, green else red.

I cannot select field in the table inside project.

😞

Thanks for all

Re: Change imagem - Two conditions - Textbox

vvira1316 — Fri, 20 Apr 2018 12:03:30 GMT

I'm trying to understand your need as it is not clear from your text in latest reply.

If I'm understanding you correctly here then I think you want image to appear without making any selection.

It will not appear in a single text object when you have multiple data (multi row dataset) values

May be you can use table chart as seen from my previous reply.

Re: Change imagem - Two conditions - Textbox

Anonymous — Fri, 20 Apr 2018 12:09:12 GMT

Exactly this :

If I'm understanding you correctly here then I think you want image to appear without making any selection.

thank you

Re: Change imagem - Two conditions - Textbox

vvira1316 — Fri, 20 Apr 2018 12:25:14 GMT

you will not be able to do using text object. For Text Object you will have to make selection. Did you understand the image functionality that I did in Table chart?

May be you want to provide a larger and proper data set with exact requirement from data and functionality you are trying to provide to users. That may help to help you.

Re: Change imagem - Two conditions - Textbox

Anonymous — Fri, 20 Apr 2018 12:33:30 GMT

I got that. Thank you so much.