topic Dynamic label generation approach used in Financial Controlling Demo Application in QlikView

Dynamic label generation approach used in Financial Controlling Demo Application

Thu, 17 Feb 2011 16:37:38 GMT

Hi All,

I am new to Qlikview and i was exploring the Financial Controlling Demo Application. I have noticed that for Label generation of Various Expression below logic is being used. Between two lable only field poistion is changing(like 14, 15 etc).

fieldvalue($(vLanguage),14)

I have tried reverse engineering the code but could not find the exact logic. I understand (vLanguage) is a varibale which have values from Language table but langugae does have only three rows. Not sure from where various label values are getting poulated using this varibale.

Regards

Dynamic label generation approach used in Financial Controlling Demo Application

pover — Thu, 17 Feb 2011 20:02:35 GMT

The function fieldvalue('field1',14) will return the 14th value loaded in the field 'field1', so the variable vLanguage returns the column (eg. 'EN') and returns the 14th value in that column that returns the label.

Regards.

Dynamic label generation approach used in Financial Controlling Demo Application

Mon, 18 Apr 2011 07:24:22 GMT

Thanks Karl,

I got the logic.

Re: Dynamic label generation approach used in Financial Controlling Demo Application

kalyandg — Tue, 06 Aug 2013 08:44:14 GMT

Hi Karl,

I am developing Qlikview application for Finance to my customer, so i was asked to do application as it is in the financial controlling application.

I have doubt in the expression, how do you bring the field which has multiple expressions in it as values,

for example refering the dashboard sheet, profit and loss sheet, u have put actual ytd, but this field has expressions in it as values, how do that map with P&L Names, and gives a respective value, pls explain

Thanks,

Kalyan