Set Analysis

[pallvit_01]

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.

[pradosh_thakur]

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

[Sue_Macaluso]

Hi, Is this for QlikView or Sense? Id like to move it into the correct product forum.

[pallvit_01]

Hi, 

I am Using same expression in both QlikSene and QlikView.

Best Regards.

Pallvit Pratap