topic Re: get selected fields in QlikView

get selected fields

Tue, 02 Dec 2014 07:30:37 GMT

Hi all,

i want to show how much fields selected in my module, is there anyway to do it?

Thanks!

anbu1984 — Tue, 02 Dec 2014 07:34:46 GMT

=SubStringCount(GetCurrentSelections(),':')

its_anandrjs — Tue, 02 Dec 2014 07:37:31 GMT

Hi,

Yes you can by create the variable with use of the NoOfFields('TableName') and then use this variable for count of the fields

TableName:

LOAD * Inline

[

Field1,Field2,Field3,Field4,Field5

1,2,3,4,5

4,5,6,3,5

];

LET vNoOfFields = NoOfFields('TableName');

It will give 5.

Regards,

Anand

Tue, 02 Dec 2014 07:45:36 GMT

Great Thanks