topic Re: Show available values in test box in QlikView

Show available values in test box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Show available values in test box

Anil_Babu_Samineni — Fri, 23 Jun 2017 06:23:32 GMT

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

Re: Show available values in test box

Anonymous — Fri, 23 Jun 2017 06:25:21 GMT

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

Re: Show available values in test box

prat1507 — Fri, 23 Jun 2017 06:28:14 GMT

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

Regards

Pratyush

Re: Show available values in test box

Anil_Babu_Samineni — Fri, 23 Jun 2017 06:30:52 GMT

Like this?

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

Re: Show available values in test box

antoniotiman — Fri, 23 Jun 2017 06:34:53 GMT

Hi,

MaxString([Feed Back])

in Text Box.

Regards,

Antonio