Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

list

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

any sugg

1 Solution

Accepted Solutions
atoz1158
Creator II
Creator II

Hi

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

View solution in original post

3 Replies
atoz1158
Creator II
Creator II

Hi

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ramasaisaksoft

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

for example

DogIdDogName
1Rex
2Jack
3Jack
4Ginger
5Clancy
6Casey
7Casey
8Tommy

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.

Capture.PNG.png


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