textbox

[Prithika]

can someone help me

In qlik sense

if I selected a value in a field in filter pane, Text box should show the selected value and it should also 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, on textbox it should show the name Harikrishna and it should show attendance status and  punch time without selection. is there any possible expression?

[justISO · Accepted solution]

Hi, add 'Text & image' chart to your report and write text you need with additional measures, something like this:

where measures checking if only one student is selected and showing corresponding values and looks like this:

if(GetSelectedCount(student)<>1, 'select 1 student', student)

if(GetSelectedCount(student)<>1, '-', attendance)

if(GetSelectedCount(student)<>1, '-', time)

[Prithika]

it is showing error what should i do pls help me

 

[justISO]

GetSelecetedCount() is a function, you forgot to put brackets (as error indicate):

if(GetSelecetedCount([Student Name])<>1, 'select 1 student', [Student Name])

[Prithika · Accepted solution]

i got it thank you so much.

if(GetSelectionCount([student name]<>1),'select a student name',[student name])

if(GetSelectedCount([student name]<>1), '-', attendance)

if(GetSelectedCount([student name])<>1), '-', time)

i have been stuck in this for 2-3 days

thank you so much.