topic Re: Set Analysis in QlikView

Set Analysis

pallvit_01 — Mon, 18 Feb 2019 12:42:21 GMT

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.

Re: Set Analysis

pradosh_thakur — Mon, 18 Feb 2019 12:56:28 GMT

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

Re: Set Analysis

Sue_Macaluso — Mon, 18 Feb 2019 19:12:51 GMT

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

Re: Set Analysis

pallvit_01 — Mon, 25 Feb 2019 11:38:49 GMT

Hi,

I am Using same expression in both QlikSene and QlikView.

Best Regards.

Pallvit Pratap