Set Analaysis to get the Name of the people

[#1]

Hi ,

Currently we are using the Set Analysis to get the sum of the premium for all the years ">=" to the year selected. i.e If the year selected is 2011 I will use the set analysis to get the premium >= 2011. Given below the function I am using.

num# (round(Sum({$< Expiry_Year={">=$(vMaxYear)"} >} $(vGrossAmount))),'######')

Similarly, I want to display the name of all the employee for the year >= 2011 using set analysis or using any other function.

Could you all please advise how to do this in Qlikview  version 10.

Updated the sample qvw with explaining the problem

Thanks,

Sijo

[SunilChauhan]

thy this

if(Year>=2011,Name)

for dynamic

take var=max(year)

and then

if(Year>=$(var),Name)

hope this helps

[#3]

Hi Sunil,

Thanks for the update.

The above example will not work in my scenario as there will be always a year selected.

i.e We need to select a year (2011) from the list box and we need get the list of the names >= 2011. In the formula given above will only give the names for the year selected although we are putting '>='.