Skip to main content
Announcements
Qlik Acquires Upsolver to Advance Iceberg Solutions: READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic label generation approach used in Financial Controlling Demo Application

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

1 Solution

Accepted Solutions
pover
Luminary Alumni
Luminary Alumni

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.

View solution in original post

3 Replies
pover
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Thanks Karl,

I got the logic.

kalyandg
Partner - Creator III
Partner - Creator III

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