topic Select all values in QlikView

Select all values

Fri, 17 Jun 2011 11:22:29 GMT

Hello QV Experts

ActiveDocument.Fields("SheetID").GetPossibleValues will not fetch all values. But I want to include everything including duplicates. Please suggest.

Thanks & Regards

Fri, 17 Jun 2011 11:54:52 GMT

try this

valuescommaseperated= ActiveDocument.Evaluate("Concat(distinct([Field Name]),',')")

valuesarray= Split(valuescommaseperated,",")

then use foreach loop as

for each value in valuesarray

msgbox value

Fri, 17 Jun 2011 11:59:18 GMT

do not use distinct if you want duplicates also.

Fri, 17 Jun 2011 12:09:33 GMT

Hi Swapnil,

Below code fetches me only one value, whereas table contains 46 rows all are numbers.

valuescommaseperated= ActiveDocument.Evaluate("Concat([Indx],',')")

valuesarray= Split(valuescommaseperated,",")

msgbox(valuescommaseperated)
for each value in valuesarray

msgbox value