topic Re: how to use subfield function in only in QlikView

how to use subfield function in only

Mon, 08 Jul 2013 18:44:15 GMT

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))

Re: how to use subfield function in only

Gysbert_Wassenaar — Mon, 08 Jul 2013 19:06:57 GMT

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).

Re: how to use subfield function in only

Mon, 08 Jul 2013 19:11:21 GMT

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

Re: how to use subfield function in only

Mon, 08 Jul 2013 19:29:48 GMT

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.

Re: how to use subfield function in only

Mon, 08 Jul 2013 19:59:42 GMT

please find attached.

Re: how to use subfield function in only

Gysbert_Wassenaar — Tue, 09 Jul 2013 07:16:27 GMT

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

Re: how to use subfield function in only

Tue, 09 Jul 2013 13:48:45 GMT

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).

Re: how to use subfield function in only

Tue, 09 Jul 2013 14:09:14 GMT

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