Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
Please help me regarding this issue.
I have application name and User base columns. In qlikview, I created a search button with application name. so whehn I click on application name automatically I should get the value of user base in atext box.
I have created a text box as user base and given the expresiion as
=If(Len(GetFieldSelections([Application Name])),[User Base],'Search for Application')
but this is not working
Try concat([User Base]) -
=If(Len(GetFieldSelections([Application Name])),concat([User Base]),'Search for Application')
I am not at all sure what you require, so i suggest that you post a small sample QVW file with some representative data, and clearly explain what you are trying to do and what result is expected.
Try concat([User Base]) -
=If(Len(GetFieldSelections([Application Name])),concat([User Base]),'Search for Application')
is this what you are trying to do?
I got it right
and similar way way I have a text box as total users, when I click on application name I need to get the total count of users in that box
Did you try count(distinct [User Base])
=If(Len(GetFieldSelections([Application Name])),count(distinct [User Base])),'Search for Application')
yes, I tried the same way.
Can you share what output you are getting, ensure you are counting the correct field.
attaching qvw file and excel
having personal edition so cannot access qvw but as per your data sample, I think you should use sum([# of users] instead of count.