Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner
Partner

How to show current month and previous in the same table with month as a dimension

Hi,

I want to show Current month Sales and previous month sales with the month as a dimension..

Its Urgent...

Please provide ur solution ASAP.

1 Solution

Accepted Solutions
sunny_talwar

Check this:

=If(Sum(Act_Amt) > 0, If(Num(Month) > 1, Before(Sum({<Month, [Month Year], Date, Year>}Act_Amt)), After(Sum({<Month, [Month Year], Date, Year>}Act_Amt), 11)))

View solution in original post

12 Replies
settu_periasamy
Master III
Master III

Hi,

Check this..

Show Today's Sales and Same Day Last Year's Sales

You can try to use with Above ()..

sunny_talwar

This?

Capture.PNG

Expression for Previous Month:

=Before(Sum(Act_Amt))

sunny_talwar

I think you might not have opened the attachment. The chart used is a pivot table and required to use Before() function to get the previous value.

settu_periasamy
Master III
Master III

Yes.. I'm posted using my mobile.. thank you..

sunny_talwar

kavita25
Partner
Partner
Author

It doesnt work on selection....it gives null...

sunny_talwar

What selections are you making?

sunny_talwar

Try this expression:

=If(Sum(Act_Amt) > 0, Before(Sum({<Month, [Month Year], Date, Year>}Act_Amt)))

Capture.PNG

kavita25
Partner
Partner
Author

On click, its working now, But If its Jan it should show for Dec Previous Year...Now its showing null