Display (text) field value based on specific value

[peterderrington]

Hi,

So i've probably made this sound more complex than it needs to be.

I have a specific KPI sheet that i want to display the names of specific people.

If i use the simple expression of [Their Name] and then select the particular value in the [Location] field then it will show the text values that are in that field however i want it to always show the values from a specific value within the [Location] field.

So what is the syntax i need for it to display: "Bob" (which is a name within the [Their Name] field which is linked to "PlaceA" (which is a value in the [Location] field.

Does that make sense?

Thanks,

Peter

[neelamsaroha157]

Hi peter, Do you mean that even with the selection in location you want to display the values from [Their Name].

For example - Bob belongs to 'palceA', so when you select 'placeB', Bob should still be visible in your KPI object??

[peterderrington]

Hi,

sorry, i've really not explained this well.

This is an example of some data:

Something	SomethingElse	Their Name	Location	Date
one	one	Bob	Home	11-Oct
one	one	Fred	Work	11-Oct
one	one	charles	Home	12-Oct
one	one	John	Work	12-Oct
one	one	Bob	Home	13-Oct
one	one	Tom	Work	13-Oct

So my graph already has 'Date' has a dimension and so i would like it to display

11-Oct	Bob
12-Oct	Charles
13-Oct	Bob

This particular KPI sheet is only concentrated on "Home"

Is that any better explained?

[vishsaggi · Accepted solution]

Try this?

= Only({<Location = {'PlaceA'}>} [Their Name])

[neelamsaroha157]

Check this out -

Expression - Only({<Location = {'Home'}>}[Their Name])

[peterderrington]

Perfect!

Yet again i am bowled over by the incredibly helpful people on this site and their infinite knowledge

Thank you so much

[vishsaggi]

Check this?

Add straight table with Dim as Date

Expr: = Only({<Location = {'Home'} >} [Their Name])

[Prithika]

can someone help me

if I selected a value in a field, one kpi should show the selected value and another kpi should show the value that is related to the selected value.

for example:

student name: Harikrishna

student attendance status: present

student punch time: 8:00

if I selected Harikrishna, one kpi should show the name Harikrishna and another kpi should show attendance status and another kpi punch time without selection. is it possible?

[gq]

Qlik auto filters based on the selections you make, if you select Harikrishna related status will be shown.

You need to add name and status fields in the table or charts.