Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-05-27 01:02 PM

Above() not working to obtain previous data from pivot table with 2 dimensions

Hi,

I have a set of data where I need to obtain the previous record from the pivot table. The pivot table contains 2 dimensions ("=YEAR(MonthYear)" -->YEAR and "=MONTH(MonthYear)" -->MONTH) which is created by this field called MonthYear. To obtain the previous month's data, I use this expression: "=above(count([Complaint ID]))". Im unable to obtain the previous data for all Jan rows. Can anyone help?

Picture1.png

3,305 Views
0 Likes
10 Replies
poppypearce
Creator
Creator
‎2017-09-18 01:25 AM

In response to sunny_talwar

Sunny Your Solution is correct but i am not able to mark as Correct as this Question was raised by Jiu Yew Loh.

Thanks  a lot for your support ....

258 Views
0 Likes