topic Re: Correction in the Expression in QlikView

Correction in the Expression

Anonymous — Wed, 01 Apr 2015 11:46:56 GMT

Hi,

Please help me...Is there something wrong in this expression.

Aggr(SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY')))<=$(=Date(Max(Date)-7,'DD-MMM-YYYY'))"}>}Sales),Product)

its excluding last 7 days data. Actually I need only last 7 days data. instead of other

Thnx,

John

PrashantSangle — Wed, 01 Apr 2015 11:50:32 GMT

Hi,

Try like

Aggr(SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY')))<=$(=Date(Max(Date),'DD-MMM-YYYY'))"}>}Sales),Product)

Regards

MK_QSL — Wed, 01 Apr 2015 11:52:34 GMT

Assuming that your Date field is in DD-MMM-YYYY format.

SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY'))<=$(=Date(Max(Date),'DD-MMM-YYYY''))"}>}Sales)

SUM(Aggr(SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY'))<=$(=Date(Max(Date),'DD-MMM-YYYY''))"}>}Sales),Product))

Anonymous — Wed, 01 Apr 2015 11:54:03 GMT

Tried this before.....its showing all the data...Any other Suggestions Max....

Thnx

John

MK_QSL — Wed, 01 Apr 2015 12:15:39 GMT

What is the format of your DATE field?

Anonymous — Wed, 01 Apr 2015 12:19:05 GMT

Thnx Manish,

the second expression did the magic...cud u pls explain why Sum before Aggr ..made this work....

Thnx,

John

MK_QSL — Wed, 01 Apr 2015 12:21:51 GMT

SUM(Sales) will create TotalSales

Aggr(SUM(Sales),Product) will create a virtual table with Product as Dimension and SUM(Sales) as Expression

But we need Total SUM(Sales) for All Products... so we need to again use SUM

SUM(Aggr(SUM(Sales),Product))

Anonymous — Wed, 01 Apr 2015 12:24:18 GMT

Excellent!!!