Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Combining Sales of two months

Dear Community,

sorry it must be a really stupid question but i try to have a simple table that Shows month, Sales, and Sales/Sales of next months in the same line.

I just cannot get it :-(

Anyone that can briefly help?

Cheers

Seb

i.e.

Month     Sales     Sales/Sales next month

Apr          1000     200%

May          500     100%

June          500    

1 Solution

Accepted Solutions
christophebrault
Valued Contributor

Re: Combining Sales of two months

Hi,

try this expression :

sum(Sales)/Below(sum(Sales),1,1)

5 Replies
christophebrault
Valued Contributor

Re: Combining Sales of two months

Hi,

try this expression :

sum(Sales)/Below(sum(Sales),1,1)

Not applicable

Re: Combining Sales of two months

Thanx christophe - this helped for now

christophebrault
Valued Contributor

Re: Combining Sales of two months

This solution isn't matching exactly your needs ?

Not applicable

Re: Combining Sales of two months

yes it indeed did - thanx a lot again.

christophebrault
Valued Contributor

Re: Combining Sales of two months

Ok, no problem.

Just a tip for the Qlik Community :

Turn to green when your problem is solved.

Bye

Community Browser