Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Thank you!! It worked!!!
You have put wrong field named Date instead of Period.
PFA, hope it helps.
Thank you!! It worked!!!
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