topic Re: Text Object - return value from table when IF statement matches in QlikView

Text Object - return value from table when IF statement matches

nigelapt — Sat, 16 Nov 2024 00:00:01 GMT

Hi Folks

Hoping for some advice on a simple Text Object.

I have a simple table loading in from SQL with two fields, for example:

Group Name, Group Members

Domain Controllers, 300

SQL Servers, 1500

I just want to match the Group Name and return the number of Domain Controllers in a text box.

=if([Group Name]='Domain Controllers',[Group Members])

However it is just returning a hypen "-"

Any advice would be appreciated.

Thanks

Nigel

Taoufiq_Zarra — Thu, 10 Sep 2020 12:33:56 GMT

@nigelapt Maye be :

=Only({<[Group Name]={'Domain Controllers'}>} [Group Members])

output :

nigelapt — Thu, 10 Sep 2020 12:44:46 GMT

Hi Taoufiq , thank you so much for taking time to help me.

Spent all morning searching for an answer and your's worked first time!

Many thanks

Nigel