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

last 3 months print records in a pivot table

HELLO

I need help!

I have a table called work scheduled on that table have a date which shows the progress of these works, but dates until 2019 mark

my table and mark the progress of these current record is 2015, every 15 days made a cut on the progress of the work, so my log table has cut eg

01/15/2015

30/01/2015

02/01/2015

15/02/2015

up to: 31/08/2015

as I can do to show in a pivot table only the last 3 months or 6 cuts last 15 days records progress:

for instance:

15.06.2015,

06/30/2015

15/07/2015

07/31/2015

08/15/2015

08/31/2015

but only consider the records of progress of works and not consider the records until it reaches the scheduled work to date = 2019

Thank you

5 Replies
sasiparupudi1
Master III
Master III

please post a sample

Not applicable
Author

Thank you

looking send you a picture of my tables is related by date, day, month,

My table shows programmed works scheduled dates of the works that reach 2019

My table shows the dates forward Real progress leading every 15 days, and then get through 2016. I want is that in the date field when placed in the pivot table only shows me the three months of the progress of works

colo an image like this my pivot table and show me the dates to the year 2009-2019

I just need to show the dates for example:


15/06/2015

06/30/2015

15/07/2015

31/07/2015

15/08/2015

31/08/2015ejemplo1.dib

ejemplo2.png

qlikviewwizard
Master II
Master II

Hi,

Can you share the sample file to demonstrate your issue? Thank you.

Not applicable
Author

Hi,

Can you post ur qvw.

Not applicable
Author

sorry but the information is confidential I can not share, but I think it came shares allocated to them what dimensions add an added dimension and place this:

  = if (FechaMaxAvance <= Today () and FechaMaxAvance> = (Today () - 60), FechaMaxAvance)

and this gives me the last 4 cuts of the current fortnight, and I hope this good, or someone knows another solution? just know to get more knowledge

and thank you very much for your attention