Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having a data of 2006,2007,2008 3 years data using an expression For PYTD
Sum({$<OrderDate = {">=$(=YearStart(AddMonths(Max(OrderDate),-12))) <=$(=AddMonths(Max(OrderDate),-12))"}>}Sales)
which is working fine and giving me total sales of 2007 year. But when i am selecting year 2007 in my year filter.
This is expression is giving me 0.
If I am using following expression
Sum({$<Year =, OrderDate = {">=$(=YearStart(AddMonths(Max(OrderDate),-12)))<=$(=AddMonths(Max(OrderDate),-12))"}>}Sales)
Then it is working fine for my year filter.
May anybody tell me what is the difference in those 2 expressions & why is data coming 0 for my first expression which i mentioned.
Regards.
Sum({$<Year =, OrderDate = {">=$(=YearStart(AddMonths(Max(OrderDate),-12)))<=$(=AddMonths(Max(OrderDate),-12))"}>}Sales)
The "Year= " nullify any selection made on the year so year doesn't affect your expression any more. Where as the associated value are there and your max order date is somewhere in 2007 and you get the data for 2006 with the help of " orderdate ={">= .... "} " expression.
Thanks
Pradosh
Hi,
I am Using same expression in both QlikSene and QlikView.
Best Regards.
Pallvit Pratap