topic Re: How to list sales increase and new customer from sales increase list ? in QlikView

How to list sales increase and new customer from sales increase list ?

paulyeo11 — Thu, 23 Jun 2016 15:15:34 GMT

Hi All

After you successfully help me on sales decline listing to break into 2 table.

Now I have another list , which is sales increase listing table 1 Row 1 to 6 into Table 2

when i try to follow the same approach , I manage to display 3 company only . i miss out 3 company. not sure why ?

For new customer listing. Table 3., i try to filter Row 6 till 24 from Table 1 , i try to follow the same approach , but i still stuggle with it. Hope you can advise me.

Re: How to list sales increase and new customer from sales increase list ?

paulyeo11 — Thu, 23 Jun 2016 15:16:26 GMT

my QVW

Re: How to list sales increase and new customer from sales increase list ?

paulyeo11 — Sat, 25 Jun 2016 08:51:21 GMT

Hi Manish

Above is the report i expected for sales increase list.

Below is the report i expected for sales increase from new customer.

Re: How to list sales increase and new customer from sales increase list ?

MK_QSL — Sat, 25 Jun 2016 18:01:19 GMT

1st Table

1st Expression

if(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

)

2nd Expression

If(Column(1),if(

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate),

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate))

)

3rd Expression

=If(Column(1),if(fabs(column(1))=0,1,column(2) / fabs(column(1))-1))

4th Expression

If(Not IsNull([YTD Variance]),1,0)

2nd Table

1st Expression

If(

if(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

)

=0,

if(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

))

2nd Expression

If(Column(1) = 0,if(

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate),

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate))

)

3rd Expression

=if(fabs(column(1))=0,1,column(2) / fabs(column(1))-1)

4th Expression

If(Not IsNull([YTD Variance]),1,0)

Re: How to list sales increase and new customer from sales increase list ?

paulyeo11 — Sun, 26 Jun 2016 00:06:27 GMT

Hi Manish

Now working fine .

1) I make many mistake on 0 or 1 and > and <

2) Lucky you give me the expression , in case you only give me QVW , i don't think i am able to download as now my internet slow.

Great that now it every thing okay. are you work and live in Singapore ?

Paul