Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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)

Not applicable
Author

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

Not applicable
Author

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)

er_mohit
Master II
Master II

See the attached qvw