Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

Hi,

try this expression :

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

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin

View solution in original post

5 Replies
christophebrault
Specialist
Specialist

Hi,

try this expression :

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

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable
Author

Thanx christophe - this helped for now

christophebrault
Specialist
Specialist

This solution isn't matching exactly your needs ?

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable
Author

yes it indeed did - thanx a lot again.

christophebrault
Specialist
Specialist

Ok, no problem.

Just a tip for the Qlik Community :

Turn to green when your problem is solved.

Bye

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin