topic Re: Set Analysis question in QlikView

Set Analysis question

Mon, 19 May 2014 15:36:43 GMT

Hi,

I have a chart either pivot table or straight table. now i need to create a column which should do count of selections made. Example if i make selection on one list box the count should be one , if the selcitions are two then one more row should add in that column as two.

the values should dynamically increase in that column as per the selections made.

Do respond me with set analysis expression

Re: Set Analysis question

Mon, 19 May 2014 15:41:19 GMT

If the list box is one, try to use

=getselectedcount(Field)

as expression of column,where field is the field of list box.

Re: Set Analysis question

Mon, 19 May 2014 15:49:48 GMT

Hi,

Mario thanks for your quick and sharp response, but what if we make sections in more than one list boxes

Re: Set Analysis question

Mon, 19 May 2014 15:50:48 GMT

=getselectedcount(field1) + getselectedcount(field2) + ...

Try this?

Re: Set Analysis question

preminqlik — Mon, 19 May 2014 15:53:23 GMT

=getselectedcount(field1)+getselectedcount(field2)+getselectedcount(field3)+.....

Re: Set Analysis question

Mon, 19 May 2014 15:54:02 GMT

Hi Jacob,

It works fine

Re: Set Analysis question

Mon, 19 May 2014 16:00:56 GMT

try this:

=SubStringCount( GetCurrentSelections(' | ', '::', '::'),'::')