topic Re: Dynamic Count By Year in QlikView

Dynamic Count By Year

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Kind regards, Farrukh

yujiyamane — Tue, 27 Feb 2018 03:25:33 GMT

Hi Farrukh,

Did you want something like one attached?

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

yujiyamane — Tue, 27 Feb 2018 03:38:28 GMT

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 — Tue, 27 Feb 2018 11:28:32 GMT

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 — Tue, 27 Feb 2018 23:13:01 GMT

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

yujiyamane — Wed, 28 Feb 2018 02:46:47 GMT

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 — Wed, 28 Feb 2018 10:35:15 GMT

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 — Wed, 28 Feb 2018 20:53:59 GMT

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

Have a good day.