Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display name by using key

I want to display a name by a ID, so i can identify if have 2 same names but with 2 different keys (ID)

I got this expression

=if(DWID_Medarbejder <> 1888, DWID_Medarbejder)

This shows all my workers ID except 1888. How can i comebine a name on this?

So i would get for an example

"Thomas Jensen 454"

"Michael Hansen 455"

"Thomas Jensen 456"

"Peter Pedersen 457"

and so on

And how do i do it in a bar chart? Is that just a calculated dimension?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Something like this maybe if the name is in field MedarbejderName:

=if(DWID_Medarbejder <> 1888, MedarbejderName & ' ' & DWID_Medarbejder)

In a (bar)chart you'd probably use this in a calculated dimension. It doesn't make much sense to use it as an expression.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

Something like this maybe if the name is in field MedarbejderName:

=if(DWID_Medarbejder <> 1888, MedarbejderName & ' ' & DWID_Medarbejder)

In a (bar)chart you'd probably use this in a calculated dimension. It doesn't make much sense to use it as an expression.


talk is cheap, supply exceeds demand
Not applicable
Author

And how do i remove a certain name in my barchart..

EG.

I see top 10 names in my bar chart, but one of the names is a Dummy

I do not want to show the Dummy because it mess up my barchart. Can i exclude that somehow???

Cause when i do like this

=if(DWID_Medarbejder <> 'Dummy', DWID_Medarbejder)

it gives me - in the barcharat

Not applicable
Author

Ahh yes ofc! Can you make help me with the solution on what i wrote underneath ?

How to remove an value in barchart?

its_anandrjs

Write some like

=if(DWID_Medarbejder <> 1888 and DWID_Medarbejder <> 'Dummy', Medarbejder_Name & ' ' & DWID_Medarbejder)

HTH

Regards,

Anand

Not applicable
Author

I actually just did before you wrote!

=if(Medarbejder.Navn <> 'Dummy', count(DISTINCT DWID_skaffetsagen))

Thank you both for the fast answers!