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: 
rido1421
Creator III
Creator III

Straight Table with Variances

Hi There

I would like to create a Table with a variance between the previous day and the Current day.

What could I use in the set analysis to achieve this variance and variance Percentage?

   

Date Sales AmountVarianceVariance%
201507011000000%
2015070212000200020%
201507039000-3000-25%
201507045000-4000-44%
201507051500010000200%
201507063000-12000-80%
201507071800015000500%

Thank you

1 Solution

Accepted Solutions
tresesco
MVP
MVP

4 Replies
tresesco
MVP
MVP

PFA

rido1421
Creator III
Creator III
Author

WOW! Thanks

Kushal_Chawda

Please find the attached

ankitbisht01
Creator
Creator

1.Expression 1 = sum[(Sales Amount])

2. expression 2 =sum([Sales Amount])- Above([Sales Amount],1)

3. Expression 3 = = (sum([Sales Amount])-Above([Sales Amount]))/Above([Sales Amount])

PFA

Regards

Ankit Bisht