Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i store the pssoble values of listbox in different variables.
PFA,
I want the variables to use in a chart dynamically
The aggregation function will target your current data set, which include both selected values and possible values. A list box shows the values in a field, so by using Concat() you can concatenate all values in the field. For example =Concat(DISTINCT Month, ',') gives you a comma separated list of the filed values.
I am very unclear on why you want to store each value in separate variables. What is your use case with that?
You can pick a specific value from the list by using a function that allows indexes. For example =Max(Month) or =Max(Month, 1) returns the largest value, while =Max(Month, 3) gives the third largest.
Toni,
Thanks for the reply. Max(Month,1) returns 3 here not the month name.
i guess i have to use maxstring() but still Maxstring(field,1) not workin either
For 3rd min value you can try like: =FirstSortedValue(Month, Aggr(Month,Month),3)