Dynamic Count By Year

[Anonymous]

Hi All,

I am trying to create a straight table with Dynamic Counts by Year as shown below: which pick the column by year and count the F2 value.

Can you please advise me how this can be sorted.

I have attached the sample excel result file and qvw too.

F2	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017
10-11		1				1	1
10-12			1		1		1	1	1	2
10-13	1			1
10-14		1							1
10-15	1						1		2		1
10-16								1	1
10-17				1					1
10-18				1
10-19						1				1

Kind regards, Farrukh

[yujiyamane]

Hi Farrukh,

Did you want something like one attached?

Let me know if you want me to give you one as straight table.

[yujiyamane]

The attachment application shows you the chart in Pivot and Straight table objects. Hopefully you like them.

Please let me know if i can be of any more help.

Yuji

[Anonymous]

Hi Yuji,

As you can see in my initial attachment. I have two straight table the first table does not show 2018 year. Its only showing 2017.

The second table shoes the count for 2018 but does not show the Year Value.

Kind regards,

Farrukh

[yujiyamane]

Would you be able to supply me the test load data to have a look further?

[yujiyamane]

Your date max date value is '15th Dec 2017'.

I can see 2018 dates in period field so it should be something wrong when you import Period data for calendar generation process.

I assume that you should import the period field with distinct Date (Period) and then find the min and max.

If you can give me the Draw.xlsx data source. i can have a look further.

Yuji

[Anonymous]

Hi Yuji,

This has been resolved. I was importing two different files, one by Master Calendar and Second as a data file. first file does not has the year 2018.

Now its working properly.

Kind regards,

Farrukh

[yujiyamane]

It is great to know you found the cause and resolved it.

Have a good day.