topic Re: Increase in Sales in QlikView

Increase in Sales

nilesh_gangurde — Thu, 16 Jan 2014 07:56:12 GMT

Hi,

How we can find out the increase in the sales amount for perticular Date range.

-Nilesh

Thu, 16 Jan 2014 08:00:03 GMT

Do you mean to say the user hast to select the date range "From and To date"

nilesh_gangurde — Thu, 16 Jan 2014 08:01:22 GMT

No i have two colums Start Date and End Date.

-Nilesh

sujeetsingh — Thu, 16 Jan 2014 08:24:47 GMT

Just select the value and see the expression change

salto — Thu, 16 Jan 2014 08:26:55 GMT

Do you mean the sales percentage varitaion between two different time periods?

In that case divide the sales amount in the second period and the sales amount in the first period.

For a particular Year the set analysis expression could be something similar to:

=sum({<Year={$(=max(Year))}>} SalesAmount) / sum({<Year={$(=max(Year)-1)}>} SalesAmount)-1

Thu, 16 Jan 2014 08:34:51 GMT

Do you want to compare the start date sales with End date sales(Increased)? then follow the SALTO's comment....