how to use subfield function in only

[#1]

i got to show dimensions as expressions (to avoid scroll bar issue). and those list of dimensions created as a inline table and shown as list box. dimensions will display based on user selection from the list box.

how to use the subfield function with in only function ? below syntax is getting me nulls.

only(subfield(concat([PrescriberListFields], ','), ',', 1))

[Gysbert_Wassenaar]

You already used an aggregation function in the expression so you need to use the aggr function:

only(aggr(subfield(concat([PrescriberListFields], ','), ',', 1), dim1, dim2,...etc)

Replace dim1,dim2,...etc with the dimensions of your chart

edit: But you don't the only function. It's redundant since the concat function already aggregates to the dimensions in your chart. Try simply subfield(concat([PrescriberListFields], ','), ',', 1).

[#3]

if i use only(Speciality) it works fine, where speciality is the dimension name. subfield function also results the same name.

[#4]

it just repeats the word 'Speciality' in every row.

what will be the syntax to have use only function ?

only(subfield(concat([PrescriberListFields], ','), ',', 1))

Thanks for your time.

[#5]

please find attached.

[Gysbert_Wassenaar]

See attached qvw. It contains a number of guesses of what you might want.

[#7]

I am trying to have dynamic dimension fields. if i have more number of fields as dimensions i am getting the scroll bar issue as qlikview gives scroll only for expressions. so i am trying to have dimension in expressions.

your expressions just repeating the field name. i am trying to achieve prescriberid in expression to show actual values (ex:1,2,3,4,5).

[#8]

Hi,

please see the Report TAB in the "Whats New in QV 11" app.

Hope you get some helpful hints to reach your goal!

Good luck!!!

Rainer