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: 
vinieme12
Champion III
Champion III

Compare with Count AsOf Previous day in Pivot

Hi

I have a pivot table showing count of Activities recorded for AsOf each day for last three months.

What i want is highlight changes as compared to previous day,

Example

if count for OCT'16

AsOF 4Jan = 100

AsOF 5Jan = 120 <Greater than previous day

AsOF 6Jan = 110 < Less Than Previous day

stalwar1‌‌  swuehl‌   gwassenaar

Attached is sample app.

AsOFHelp.PNG

Many Thanks

Vineeth

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
1 Solution

Accepted Solutions
sunny_talwar

May be this as background color expression:

If(Column(1) > Before(Column(1)), LightRed(),

If(Column(1) < Before(Column(1)), LightGreen()))

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

The attached sample only has 2 dates, right? 1/4 and 1/5? The image shows 4 dates... I guess that should be fine, but just wanted to make sure I am looking this right?

vinieme12
Champion III
Champion III
Author

yes it only has 2 dates; just started with the app,

I just added more dates for the example to be clearer

Thanks for looking into it

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

May be this as background color expression:

If(Column(1) > Before(Column(1)), LightRed(),

If(Column(1) < Before(Column(1)), LightGreen()))

Capture.PNG

vinieme12
Champion III
Champion III
Author

Thanks a lot Sunny

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.