topic Re: value result as a label in QlikView

value result as a label

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

I have a table with a number of fields and 2 of them are

Manufacturer & Region

I would like the label of the expression to be shown as the manufacturer based on a specific region.

I tried the below formula:

=if([Region]='NA',Manufacturer,)

Where 'NA' is a data response in the Region Field. There are no duplicates in the Region field either. I also tried the same formula as a separate expression with no bar and text on Axis selected. The resulting label and result is blank. Any ideas?

Re: value result as a label

petter — Wed, 05 Feb 2020 19:33:22 GMT

How about trying this:

=Concat( DISTINCT {<Region={NA}>} Manufacturer, ' / ')

Re: value result as a label

petter — Wed, 05 Feb 2020 20:01:17 GMT

Please click the like button or heck if the response was correct you could even mark it as a correct solution.
Believe me - it will be greatly appriciated by the contributors ...
We love likes as much as anyone posting anything on social media

Re: value result as a label

EGilbert — Wed, 05 Feb 2020 20:08:32 GMT

Worked great. Thanks for the suggestion

Re: value result as a label

EGilbert — Thu, 06 Feb 2020 15:32:40 GMT

Thanks again for the help. I have added to my dataset and I now would like to show the OEM based still on region but with the highest Utilization in that region. In the first table each region had 1 OEM/line of data. I now have multiple OEMs per region and I would like to select the one with the highest amount in the 'Utilization' Field. I tried using the same concat function and added the max formula I used to get the value in the bar graph but it did not work. Any ideas on this one?