Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I'm working with the following expression and I believe it's correct, and providing the correct value for me, but Qlikview is saying there is an error in expression.
What am I doing wrong?
Thanks for your assistance,
Best regards
I think your date field is called PERI... you need to replace the word Date with PERI
It's wierd, look at that!
Not the expression is ok, but the expression is not working...
Hi,
Please try this,
sum({=$(=Date(MonthStart(PERI,-12)),'DD/MM/YYYY') <=$(=Date(Max(PERI)))'}>} LOPP)
Please try to make same format of
Date or PERI, whatever is your dimension field. Thanks, Vishal Waghole
Thanks for your assistance, but it's not working.
Please, take at look at the picture below:
After the opening curly bracket you have missed Date or PERI.
Try this
Sum({<PERI = {">=$(=Date(MonthStart(Max(PERI), -12)))<=$(=Date(Max(PERI)))"}>} LOPP)
Your expression works "Expression OK", but the result is not what I'm expecting.
Hello
Thanks for your help, but it's not working!
Would you mind to send me an example?
Thanks
What were you hoping to see?