topic Re: Set Analysis for max function in QlikView

Set Analysis for max function

Tue, 17 Feb 2015 20:04:55 GMT

I have a table that contains records that I would like to pull based on user input

The two fields in particular that I would like to use to get my value is fiscal_year and yr_prd

I have a variable that the user will enter a value for called vFiscalYr.

I need to have the set analysis pull the record that contains the fiscal year the user entered but it must pull the max for yr_prd.

The field that I want to display is called beg_balance.

how can I set this up in set analysis to pull the beg_balance based on the max yr_prd for a specific year????

sunny_talwar — Tue, 17 Feb 2015 20:11:02 GMT

Getting a little confused here, what is yr_prd here and how it is related to fiscal_year?? Can you provide some sample data with expected output?

Best,

maxgro — Tue, 17 Feb 2015 20:13:07 GMT

sum({$ <fiscal_year={$(vFiscalYr)},yr_prd={$(=max(yr_prd))}>} beg_balance )

Tue, 17 Feb 2015 21:08:49 GMT

sunindia

here is a sample of the table.

so if the user enters 2014

then it should pull $494.76 since this is the max yr_prd for 2014.

I'm trying to pull the Current_Yr_Depreciation.(sorry, I think I said begBalance earlier but it's Current_Yr_depreciation)

maxgro — Tue, 17 Feb 2015 22:37:42 GMT

sum({$ <Fiscal_Year={$(vFiscalYr)},YR_PRD={"$(=max({1 <Fiscal_Year={$(vFiscalYr)}>} YR_PRD))"}>} Current_Yr_Depreciation )