topic Re: list in QlikView

list

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

i need to display my list box only if the values are more than 2.

any sugg

atoz1158 — Wed, 17 Jan 2018 10:01:56 GMT

On the layout tab of the list box make the show conditional and use something like the following

Count(DISTINCT listfieldname)>2

Where listfieldname is the field in your listbox

Adrian

Anil_Babu_Samineni — Wed, 17 Jan 2018 11:04:46 GMT

What value are comes and How you know which are two values? Can you explain with data set?

ramasaisaksoft — Wed, 17 Jan 2018 11:30:18 GMT

Hope you want to see the list box which are having duplicate records

for example

and the following script:

[DOGNAMES]:

LOAD DogId,

DogName

FROM

[...\DogNames.xlsx]

(ooxml, embedded labels, table is Sheet1);

you will get a result like "DogName" List box.

correct me if i understand your requirement wrong

Try the following expression.

If(Aggr(Count({1}DogId),DogName)>1,DogName)