Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Reply
Not applicable
Author

Also, LYTD works fine too:

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