Show a field when making a selection for a certain value

[#1]

Hi,

I was wondering if there was a way in qlikview to show a text box after selecting a certain field.

I have a field titled 'System Name' and when I click on a value of System Name I'd like to show a box that has it's description in it.

Thanks

[sravanthialuval]

Hi,

Try this,

=GetFieldSelections(System name)

If you made any selection in system name that corresponding value will be displayed in text box.

[#3]

well, if there was a description related to "ddd", how would i get that to show in the list box?

[#4]

i tried if(GetFieldSelections([System Name], [Description])), but its saying theres an error in the expression

[Anil_Babu_Samineni]

Actual Syntax, it is

I've added ')' for GetFieldSelection and removed end of the statement.

if(GetFieldSelections([SCA Status]), [SCA Description])

If not, you may describe more with inputs and outputs

[#6]

Didn't work

This should go in the expression, correct?

[HirisH_V7]

Hi check this,

In listbox expression use this  -

 =SystemName & ' - ' &Description

In TextBox use this -

=GetFieldSelections(SystemName) &' -  ' &GetFieldSelections(Description)

PFA,

HTH,

Hirish

[Anil_Babu_Samineni]

Might be this expression need to copy over Text Object. If possible, Please post sample data and show me the expected output.

[avinashelite]

Description is filed ?? and does it have multiple Descriptions for that system ?

then try like this if(GetFieldSelections([System Name]),Concat(Descriptions))

[#10]

This is showing blank,

=GetFieldSelections(SystemName) &' -  ' &GetFieldSelections(Description) 

this worked, but combines both the system name and description together for each line. I want them separated