topic Expression in QlikView

Expression

Fri, 29 May 2015 08:54:04 GMT

HI Experts

I have a sales table, I want to calculate sum(sales) for Current Month and
I am using the following expression to calculate it

=Sum({< DEC_MonthYear=, DEC_Date = {'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'} >} Sales)

But Now i want changed my script and loading

Load

date,

sum(Sales)

From

Now How can I Change the expression

Fri, 29 May 2015 09:08:35 GMT

can u share qvw?

anbu1984 — Fri, 29 May 2015 09:14:31 GMT

Rename Sum(Sales) to Sales, then you don't need to change your UI expression

Load

date,

sum(Sales) As Sales

From

Fri, 29 May 2015 09:32:59 GMT

HI Anbu

Will it work the same

because I am using a dimension Customer Number

I want the sum(sales) against the customer Number

anbu1984 — Fri, 29 May 2015 10:55:32 GMT

Can you post the script

Fri, 29 May 2015 11:14:12 GMT

Hi Anbu

Here is the data

anbu1984 — Fri, 29 May 2015 11:33:17 GMT

So you want to calculate sum(Sales) from QVD data?

Can you post your script?

Is Sheet1 data different table than QVD?

Fri, 29 May 2015 12:19:41 GMT

HI Anbu

Please Provide me your emaiID I ll send the QVW to you