Show available values in test box

[Anonymous]

Hi All,

     I am having my data set like below

LOAD * INLINE [MetricName, Plant Name, Feed Back

                           MN1,PL1,

                           MN1,PL1,''2Days More"

                           MN1,PL2,

                           MN1,PL2,"Higher than Yesterday"

                           MN2,PL1," Low Value"

                         ];

So here when user selects Single Metic Name and Single Plant Name I need to show the Feed Back value. Here data may be duplicated other than Feed back column. All I need is if Feed Back value is present in MetricName& Plant Name combination I need to show the same

-Jai

[Anil_Babu_Samineni]

Let's assume if you are filtering MN1 and PL2 then how you want to show and where you want to show?

[Anonymous]

As I mentioned in the post I need to show the feed back value in the text box. If I have both Null & and Feed back value,then I need to show Feed Back only in text box

[prat1507]

Use Concat([Feed Back],',')

Regards

Pratyush

[Anil_Babu_Samineni]

Like this?

=If(GetFieldSelections([Plant Name])>0 and GetFieldSelections(MetricName)>0,  Concat([Feed Back], Chr(10)),'Feed Back')

[antoniotiman]

Hi,

MaxString([Feed Back])

in Text Box.

Regards,

Antonio