topic Re: if else statement on text object in QlikView

if else statement on text object

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

Can anyone please help me on this.

In a Text object when Category = Entertainment and ID=2 then the display name=TRUE need to be visible.

In the below sample data

Anil_Babu_Samineni — Thu, 26 Oct 2017 11:33:06 GMT

May be this?

If(Match(Category, 'Entertainment') and Match(ID, 2), 'TRUE', ' ')

tresB — Thu, 26 Oct 2017 11:34:33 GMT

Do you want to select those values and see the result or if the values are there (not necessarily selected) in scope you wish to see the output?

bhavvibudagam — Thu, 26 Oct 2017 11:39:36 GMT

Without selection only I need to get displayname. But the value TRUE is not hardcoded.

I have tried this =if(Categoty='Entertainment' and ID='2',Displayname) but

when i filter the data then only I am able to get the result.

Please help me how to get by without selections.

tresB — Thu, 26 Oct 2017 11:44:43 GMT

Try like:

=if(Max(Index(Categoty,'Entertainment')) and Max(Index(ID,'2')),Displayname)

bhavvibudagam — Thu, 26 Oct 2017 12:04:58 GMT

Hi Tresesco,

Thanks for your reply.

But its not working. Please find the attached app with error.

Actually its a sample data always Entertainment is not be the first record.

tresB — Thu, 26 Oct 2017 12:17:52 GMT

Well, a bit simplified and corrected one working:

=MaxString({<MetricGroup={'culture and behaviour'}, [RAG Ind]={'2'}>}[metric c display name])