topic Re: How to exclude past dates in Pivot table in QlikView

How to exclude past dates in Pivot table

Anonymous — Thu, 13 Feb 2014 21:18:52 GMT

Hello! Pls. see my questions below regarding my pivot table...

1. I have an Inventory item that date should always be on the 1st column being the current day ...I think the sorting won't solve this unless with the use of expression? or do you suggest taking off the date?

2. how do I exclude or hide the past dates in my pivot chart...thus, i only want to show dates that belongs to current year and future years.

3. How do I arrange my items under category columns (pls. see attached)...Like I want the Sales be be on top and receipts to be in 2nd line)..

Thus, I want my pivot to improve to look like this :

Category	2/13/2014	1/6/2014	1/13/2014	1/20/2014	1/27/2014	2/3/2014	2/10/2014	2/20/2014
Sales	600	300	300	300	300	300
Receipts	1100	1200	1300	1400	1500	1600
Inventory	5000
Open PO	700							500

Re: How to exclude past dates in Pivot table

swuehl — Thu, 13 Feb 2014 22:17:35 GMT

You can use a set expression like

=sum({<MonWeek = {">=$(=weekstart(today()))"}>} Qty)

to only show values for weeks starting from this week, and a sort by expression like

=match(Category,'Sales','Receipts','Open PO','Inventory','SalesOrder')

Re: How to exclude past dates in Pivot table

Anonymous — Fri, 14 Feb 2014 18:25:16 GMT

Hi! Swuehl

Thank you so much... My questions from no 2 and 3 have been answered...I just need to replace the weekstart with yearstart since I want the beginning of the year.

For my question no 1, how do i place the inventory value to be always on the 1st column...Will conditional formula work? How?

Tks.