topic Re: How to get the field value? in QlikView

How to get the field value?

Thu, 24 Nov 2011 08:09:05 GMT

Hi All,

I have the following records.

load * Inline

[

FiscalWeek,WeekDate

2011Wk01,2011/01/01

2010Wk01,2010/01/01

]

And I have a variable named 'vWeekDate', the default value of it is '2010/01/01'.

I want to show the FiscalWeek name in the textbox, and it is changed based on the 'vWeekDate'.

How to achieve it?

Thu, 24 Nov 2011 08:20:18 GMT

Try this expression in the textbox if you want a unique value:

=Only({< [WeekDate] = {$(vWeekDate)} >} Fiscal Week)

or if you want the max value by default:

=MaxString({< [WeekDate] = {$(vWeekDate)} >} Fiscal Week)

or if you want the min value by default:

=MinString({< [WeekDate] = {$(vWeekDate)} >} Fiscal Week)

With an example I can help you more accurate.

christophebrault — Thu, 24 Nov 2011 08:32:17 GMT

If WeekDate is unique datas, you can use :

FieldValue('FiscalWeek',FieldIndex('WeekDate',vWeekDate))

see exemple

Thu, 24 Nov 2011 08:36:57 GMT

The weekdate is not unique, how to achieve it?

SunilChauhan — Thu, 24 Nov 2011 09:26:08 GMT

see the attced file

hope this helps