topic Re: period compare in QlikView

period compare

ilanbaruch — Wed, 25 Apr 2018 13:57:39 GMT

hi all,

i'm trying to compare between two periods in the same strait table,

user selection based on a floating field (numeric date field with alias) .

expression based on a variable that holds user selection

vYearMonth=GetFieldSelections(RangeYearMonth)

tried it with:

sum( {$<yearmonth = {'=$(vYearMonth)'} , Year=,Month = > } Amount)

and

Sum({<Year=, Month=, yearmonth = {"=$(=vYearMonth)"}>}Amount)

and

sum({<Year=, Month=, yearmonth={"$(vYearMonth)"}>}Amount)

but..

non of them work

any ideas?

advanced thanks

sunny_talwar — Wed, 25 Apr 2018 14:03:35 GMT

Do you have single selection or multiple selections in RangeYearMonth? May be try this

Sum({$<yearmonth = P(RangeYearMonth), Year, Month>} Charge)

Qrishna — Wed, 25 Apr 2018 16:05:29 GMT

try - sum( {$<yearmonth = {"=$(vYearMonth)"} , Year=,Month = > } Amount) - this works only for 1 selected value.

In variable overview -->

vYearMonth

GetFieldSelections(RangeYearMonth) (dont put equal sign here)

if there are multiple selections, this doest work.

ilanbaruch — Thu, 26 Apr 2018 10:17:57 GMT

worked for both, thank you