GetCurrentField function

[#1]

Dear forum,

I have created cyclic group in finencial application for company, location, profit center etc...

but my group is not just companyid but each field is company id & ' - ' & companyname and same for location

how can i show the current active field in this group.

I went through the link http://community.qlik.com/forums/p/15846/61546.aspx#61546

but using GetCurrentField will display 10001 - ABC Company, i want its label that i put for each calculated field in group.

[marcel_olmo]

Could you explain it widely?

The solution to your problem i think it's definitely getCurrentField() because it returns to you the current field of a hierarchical or cyclic group. (It should work)

So what do you need in addition?

[#3 · Accepted solution]

You can create a new field in your script:

company id & ' - ' & companyname AS Company

[#4]

Hi Shubhasheesh,

Getcurrentfield function () does not work when you need then labels.
The better way is calculating this fields in script time.

I hope it helps you

Regards

[#5]

yes i did that already and compid & ' - ' & compdesc as comp will solve this but when i need to display the no of selected by no of total in the caption of list box then then i find this too tough.

If i want to display in list box caption - | Company 5 / 295 ........| then which field is active in this cyclic group is not working properly in getselectedcount() and getpossiblecount() functions.

ex for 5 / 295 i wrote getselectedcount ( getcurrentfield ( " Cyclic Group " )) / getpossiblecount ( getcurrentfield ( " Cyclic Group "), true ). This is not working as i expected.

[#6]

Try

Count(GetCurrentField("Cyclic Group") ) & ' / ' & Count(Total GetCurrentField("Cyclic Group") )