topic Re: My YTD Calc Not working, Why {Easy Rookie Question} ? in QlikView

My YTD Calc Not working, Why {Easy Rookie Question} ?

Mon, 26 May 2014 04:07:57 GMT

Hello,

Does anyone know why my YTD calc is not working? I followed the same logic that I have seen on other posts, but it is not working for me.

For my result, we are on a fiscal calendar and have the first 3 months loaded July, Aug, Sept. I want to be able to click on month, and see only the results from that selected month and any prior months in that year.

For example, if I click on July, I should only see July data. If I click on August, I should only see July and August data, and so on.

However, when I click on on the month, it still shows all months.

Attached is the qvw file.

Can anyone help? I'm sure there is some some detail I am missing.

Thanks for Taking the time to review my question!

Re: My YTD Calc Not working, Why {Easy Rookie Question} ?

senpradip007 — Mon, 26 May 2014 04:18:18 GMT

You have put wrong field named Date instead of Period.

PFA, hope it helps.

Re: My YTD Calc Not working, Why {Easy Rookie Question} ?

Mon, 26 May 2014 04:33:42 GMT

Thank you!! It worked!!!

Re: My YTD Calc Not working, Why {Easy Rookie Question} ?

Mon, 27 Apr 2015 15:36:31 GMT

I have kind of similar question: I n one table, I am counting the number of unitd dold with the formula:

sum({<MonthNum={$(=Max(MonthNum))}>}[Units Solds])

that mean if I selected several month, QlikView provides the data for the latest month and this works perfectly.

In a second table, I'd like to display the YTD units sold and I was expecting that the following formula should do it:

sum({<MonthNum<={$(=Max(MonthNum))}>}[Units Solds])

but it is not processing. Any help is welcome.

Pierre