Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1) Sum( {$<Year = (Year + {“20*”,1997}) – {2000} >} Sales )
2) Sum( {$<Year = Year + ({“20*”,1997} – {2000}) >} Sales )
What is the difference between 1 and 2?
When I search that the only useful link is this:
I might be missing it, but not sure where is the above expression in the set of example?
ahhh, you have to search in the inbuild qlik help
Using QlikView 12, so it takes me to the online help
here you go 🙂
Got it, thanks
I think what threw me off was Year = Year was used instead of Year = p(Year).