how to get all possible values of a field

[#1]

Hi,

I have a field and I want to iterate over this field in macro. I tried using getPossibleValues but it gives only the selected values so can anybody please tell me whether there is any function to get all values irrespective of the selection.

Thanks,

[#2]

Hi Sanket,

I have two tables in data base I want to map two columns from these 2 database tables.

Now what I have done is, I have written a query in script to map these columns and then get them in a field in the format column1:column2

Now in the graph based on user requirements column1 value will be displayed. But along with column1 I need to display column2 value as well. So I'm just iterating through column1:column2 field created above and getting corresponding column2 .

[Anonymous]

How many distinct possible values are there in your field, Are they more than 100?

  The default limit is 100.  You can increase it by adding a parameter, for example:
...GetPossibleValues(1000)..

Try using it...

Hope it help you out

Regards

Nitin

[sanketkhunte]

Kavita,

My suggestion is : In that case you should not go through MICRO as it has lot of limitations and not sure whether it work or not on access point.

Your requirement is automatically satisfy by Qlikview's in build behaviour of Data Discovery.

Please send me your sample file ; and few line of what exactly you want. I will provide you solution file by forming relation between your 2 tables.

Thank you.

Sanket

[#5]

Hi Nitin,

Thanks for the ans

I tried it again and it worked.. I need not take additional field I can iterate using original field. As there is no list box created for this field so its values will never be selected so iteration happens over all elements.