Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Text Object - return value from table when IF statement matches

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

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Master
Master

@nigelapt  Maye be :

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

 

output :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Highlighted
Master
Master

@nigelapt  Maye be :

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

 

output :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Highlighted
Contributor III
Contributor III

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