topic Re: Show a field when making a selection for a certain value in QlikView

Show a field when making a selection for a certain value

Thu, 02 Feb 2017 04:42:06 GMT

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

Re: Show a field when making a selection for a certain value

sravanthialuval — Thu, 02 Feb 2017 04:59:44 GMT

Hi,

Try this,

=GetFieldSelections(System name)

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

Re: Show a field when making a selection for a certain value

Thu, 02 Feb 2017 05:16:59 GMT

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

Re: Show a field when making a selection for a certain value

Thu, 02 Feb 2017 05:22:53 GMT

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

Re: Show a field when making a selection for a certain value

Anil_Babu_Samineni — Thu, 02 Feb 2017 05:27:13 GMT

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

Re: Show a field when making a selection for a certain value

Thu, 02 Feb 2017 05:29:30 GMT

Didn't work

This should go in the expression, correct?

Re: Show a field when making a selection for a certain value

HirisH_V7 — Thu, 02 Feb 2017 05:30:59 GMT

Hi check this,

In listbox expression use this -

 =SystemName & ' - ' &Description

In TextBox use this -

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

PFA,

HTH,

Hirish

Re: Show a field when making a selection for a certain value

Anil_Babu_Samineni — Thu, 02 Feb 2017 05:34:19 GMT

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

Re: Show a field when making a selection for a certain value

avinashelite — Thu, 02 Feb 2017 05:36:24 GMT

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

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

Re: Show a field when making a selection for a certain value

Thu, 02 Feb 2017 05:43:07 GMT

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

Re: Show a field when making a selection for a certain value

avinashelite — Thu, 02 Feb 2017 06:33:41 GMT

try like this

=GetFieldSelections(SystemName) &' - ' &GetFieldSelections(Description,chr(10))

Re: Show a field when making a selection for a certain value

sravanthialuval — Thu, 02 Feb 2017 07:25:51 GMT

Try this,

=GetFieldSelections(System name)& ' ' & Chr(13) & ' ' & if(GetFieldSelections(System name)=System name),des)

when you select system name it will display the system name in first line and description in next line .

Re: Show a field when making a selection for a certain value

Thu, 02 Feb 2017 18:00:53 GMT

all of these are only pulling the System Name Values, the Description values are blank.

Re: Show a field when making a selection for a certain value

avinashelite — Fri, 03 Feb 2017 05:25:13 GMT

Share the sample app ...will check and get back to you

Re: Show a field when making a selection for a certain value

sravanthialuval — Tue, 07 Feb 2017 09:25:17 GMT

By using above expression in if condition it will pull the description related system name.

If you are not getting the correct result, please share your sample app.