Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
SRI8273
Contributor II
Contributor II

CHART DATA SORTING

Load * INLINE [
ID,NAME,MONTH,SALES
1,SRI,JAN,100
2,MOM,FEB,200
3,DAD,MARCH,300
4,ROSE,APRIL,400
5,DAM,MAY,500
6,DOSE,JUNE,600
7,PRA,JULY,800
8,ROJA,AUG,450
9,PRASAD,SEP,350
10,SRIKANTH,OCT,480,
11,NIKI,NOV,250
12,SAI,DEC,900
];

I WANT TO SEE ONLY LAST THREE MONTHS OF DATA  IN THE BAR CHART

Labels (1)
2 Replies
vinieme12
Champion III
Champion III

as below

=sum({<ID={">=$(=Max(ID)-2)<=$(=Max(ID))"}>}SALES)

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

thanks for the input its working