Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to restrict 3months in pivot table

hi,

I would like to know how to display 3months of a year (Current month and previous 3 months) in the pivot table.

Can someone help me to get the solution for the same.

Thanks and Regards,

Smitha

4 Replies
Highlighted
Not applicable

Can you attach your qvw file please? You can get this done easily by using a set analysis in your expression.

Sum({<Date={">=....."}, Date={"<=.."}>} Sales)

Highlighted
Not applicable

hi,

i dont have qvw file. i have to create application still. I have the requirement in xls.please find the xls for your reference.

Thanks and Regards,

Smitha

Highlighted
Not applicable

You can have 3 expressions.

expression 1

=sum(if(Month(Transaction_Date)=Month(Today),Metric)

expression 2

=sum(if(Month(Transaction_Date)=Month(Today)-1,Metric)

expression 3

=sum(if(Month(Transaction_Date)=Month(Today)-2,Metric)

Highlighted
Master II
Master II

See the attached qvw