Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

LY variable not working

Hi, I created a variable for CYTD revenue that works correctly:

Sum({$<[%dateflag_$1]={1}, [%dateflag_CYTD]={1}, $(vExcludeDateFields)>}  [Transaction Line Gross Amount])

However, when I try to replicate this for LY revenue it is showing incorrect data:

Sum({$<[%dateflag_$1]={1}, [%dateflag_LY]={1}, $(vExcludeDateFields)>}  [Transaction Line Gross Amount])

I noticed that the LY variable appears to be summing all revenue from LY through the current year. Any ideas as to what I need to do? Thanks

Tags (1)
1 Reply
Not applicable

Re: LY variable not working

Also, LYTD works fine too:

Sum({$<[%dateflag_$1]={1}, [%dateflag_LYTD]={1}, $(vExcludeDateFields)>}  [Transaction Line Gross Amount])

Community Browser