topic Re: Getfieldselection in QlikView

Getfieldselection

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

I want sum of salary for year one less than what i select.

suppose i select 2011, then i would require sum of salary in 2010

Below expression is not giving correct results.

=sum({<Date ={$(=(GetCurrentSelections(Date)-1))}>}salary)

Re: Getfieldselection

Anil_Babu_Samineni — Wed, 28 Jun 2017 02:20:24 GMT

Try like

I assume, You have year values in date field

Sum({<Date = {'$(=Max(Date)-1)'}>} salary)

I assume, you have Year field where you already declare in script like Year(Date) as Date

Sum({<Year = {'$(=Max(Year)-1)'}>} salary)

Still you want to get last year date sales you can use like below

Sum({<Date = {'$(=AddYears(Max(Date),-1))'}>} salary)

Re: Getfieldselection

shiveshsingh — Wed, 28 Jun 2017 02:24:45 GMT

No. not like that.

I have used this expression, i am building using getfieldselection, can you help?

Re: Getfieldselection

Anil_Babu_Samineni — Wed, 28 Jun 2017 02:27:35 GMT

Without knowing anything, we can't offer much. But use GetFieldSelections() may be?

Re: Getfieldselection

sunny_talwar — Wed, 28 Jun 2017 02:45:57 GMT

Your Date field contains Year?

Re: Getfieldselection

shiveshsingh — Thu, 29 Jun 2017 16:35:04 GMT

yes, year

Re: Getfieldselection

sunny_talwar — Thu, 29 Jun 2017 16:38:48 GMT

Then you best bet will be to use the expression provided by Anil.

Sum({<Year = {'$(=Max(Year)-1)'}>} salary)

Not sure why you want to complicate matters by using GetFieldSelections()? Is there a reason why you want to use this? Knowing the reason might help us give you a better response here

Re: Getfieldselection

shiveshsingh — Thu, 29 Jun 2017 16:40:56 GMT

i have done this using this Sum({<Year = {'$(=Max(Year)-1)'}>} salary), just wanted to build it through Getfieldselection..

just a curiosity

Re: Getfieldselection

sunny_talwar — Thu, 29 Jun 2017 16:41:46 GMT

If you will only select one year, then may be this

Sum({<Year = {'$(=GetFieldSelections(Year)-1)'}>} salary)