Discussion board where members can get started with QlikView.
I have a text object that I want to use to display some information about an engineer but for some reason I cannot get the text box to display the information from the Engineer table
='Engineer: ' & EngineerName & ' Manager :'&ManagerName
This displays as
Engineer: Manager : Mr. Man Ager
I cannot get the engineer name to display?
Solved! Go to Solution.
This expression on a text box will only work if there is only one EngineerName and only one ManagerName available (selected)
Hope this helps,
That’s what I have…I have two list boxes one for Manager and one for the engineers on this/her team. I filer on manager and then one Engineer. I have other objects that filter correctly on the same sheet.
What is odd is that every other field in the Engineer table will display…just not the EngineerName field. This also worked previously, I just can’t think what I did to stop it from working.
You can include a chart with the expressions
count( distinct EngineerName )
count ( distinct ManagerName)
just to confirm that you have one and only one result for each field.
If you still have problems, you can try to post some data in the community so we can take a look at fields, objects and expressions.
Yes…its driving me mad…I have a view that has a graph and multiple gauges that all filter correctly based on the selected name…it’s just the Text object for the name that refuses to work for me.
I have one text object that I’m testing with and it is set to display the four fields from the Engineer table…the only field that doesn’t display is the engineer name, the other three display correctly.