Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to display my list box only if the values are more than 2.
any sugg
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
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
What value are comes and How you know which are two values? Can you explain with data set?
Hope you want to see the list box which are having duplicate records
for example
DogId | DogName |
1 | Rex |
2 | Jack |
3 | Jack |
4 | Ginger |
5 | Clancy |
6 | Casey |
7 | Casey |
8 | Tommy |
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)