Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
vinieme12
Esteemed Contributor II

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

1 Solution

Accepted Solutions

Re: Compare with Count AsOf Previous day in Pivot

May be this as background color expression:

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

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

Capture.PNG

4 Replies

Re: Compare with Count AsOf Previous day in Pivot

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
Esteemed Contributor II

Re: Compare with Count AsOf Previous day in Pivot

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

Re: Compare with Count AsOf Previous day in Pivot

May be this as background color expression:

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

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

Capture.PNG

vinieme12
Esteemed Contributor II

Re: Compare with Count AsOf Previous day in Pivot

Thanks a lot Sunny