topic GetCurrentField function in QlikView

GetCurrentField function

Wed, 03 Nov 2010 11:52:50 GMT

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.

GetCurrentField function

marcel_olmo — Wed, 03 Nov 2010 11:56:55 GMT

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?

GetCurrentField function

Wed, 03 Nov 2010 12:14:04 GMT

You can create a new field in your script:

company id & ' - ' & companyname AS Company

GetCurrentField function

Wed, 03 Nov 2010 12:15:40 GMT

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

GetCurrentField function

Thu, 04 Nov 2010 09:24:03 GMT

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.

GetCurrentField function

Thu, 04 Nov 2010 10:54:14 GMT

Try

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