Dynamic label generation approach used in Financial Controlling Demo Application

[#1]

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

[pover · Accepted solution]

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.

[#3]

Thanks Karl,

I got the logic.

[kalyandg]

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