topic Display name by using key in QlikView

Display name by using key

Wed, 21 Nov 2012 10:38:15 GMT

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?

Gysbert_Wassenaar — Wed, 21 Nov 2012 10:41:39 GMT

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.

Wed, 21 Nov 2012 10:42:54 GMT

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

Wed, 21 Nov 2012 10:44:12 GMT

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 — Wed, 21 Nov 2012 10:47:42 GMT

Write some like

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

HTH

Regards,

Anand

Wed, 21 Nov 2012 10:49:10 GMT

I actually just did before you wrote!

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

Thank you both for the fast answers!