topic Re: Display (text) field value based on specific value in QlikView

Display (text) field value based on specific value

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

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

Re: Display (text) field value based on specific value

neelamsaroha157 — Wed, 24 Oct 2018 14:03:07 GMT

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??

Re: Display (text) field value based on specific value

peterderrington — Wed, 24 Oct 2018 14:12:06 GMT

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?

Re: Display (text) field value based on specific value

vishsaggi — Wed, 24 Oct 2018 14:18:40 GMT

Try this?

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

Re: Display (text) field value based on specific value

neelamsaroha157 — Wed, 24 Oct 2018 14:22:23 GMT

Check this out -

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

Re: Display (text) field value based on specific value

peterderrington — Wed, 24 Oct 2018 14:24:14 GMT

Perfect!

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

Thank you so much

Re: Display (text) field value based on specific value

vishsaggi — Wed, 24 Oct 2018 14:26:23 GMT

Check this?

Add straight table with Dim as Date

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

Re: Display (text) field value based on specific value

Prithika — Tue, 25 Jul 2023 10:09:15 GMT

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?

Re: Display (text) field value based on specific value

gq — Thu, 27 Jul 2023 14:49:00 GMT

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.