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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hie

i want to show my data of only 2 quarter from max date i.e if i select date 3rd april 2012 den my chart must show of data april marc feb jan dec nov what to do ??

Labels (1)
12 Replies
Not applicable
Author

Hi Sumita,

Please find the attached qvw,may be this is what you want.

Not applicable
Author

Hi Sumita,

U can use this expression

=sum({$<Period ={"$(=date(addmonths(max(Period),-1),'MMM-YY'))"}>}Sale)

Regards,

Kushal

Not applicable
Author

Thanks.....