values in text box

[riishabhz]

i have this table in excel , i want to display bgrade and pgrade on text box because i dont have much space left in my dashboard.

plus brade and pgrade depends on styleno , so every styleno has different grade .

please help me.

i tried adding bgrade in textbox but its not getting it, and showing me only bgade instead of its value like 'a' , 'b' and so on

bgrade   pgrade     styleno

a                 b              19P3096C147LG

b                 c             19P3196C147L4

basic         a             19P3496C147LG

a+             basic       19P2096C147LG

b                 a             19P1096C147LG

[ramasaisaksoft · Accepted solution]

Hi Team,

please don't open multiple threads for the same issue 

https://community.qlik.com/t5/New-to-QlikView/data-in-excel-to-text-box/td-p/1595605

Text box will give only one value ,

so if it is OK for you the add text box object in your sheet and select any one Styleno value and automatically text box will give the related value.

FYR ... i have given sample image below

(If i select  any value/Item in Destination Field/Dimension my text box will show related "Functional role")