Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have tried to obtain the last month data...(August in this case) sum and average can you help me with this?
Count({<Mes={'Date#(Month(today()))'},Datos={">0"}>} Datos) (This give value = 0)
Sum august have to be = 11654,47
and Avg = 685,5570588
Thanks!
Hi,
Just need to change the set analysis
= Count({<Date={'>=$(=monthend(today(),-1))<$(=monthend(today()))'},Datos={">0"}>} Datos)
to this
= Count({<Date={'>$(=monthend(today(),-1))<$(=monthend(today()))'},Datos={">0"}>} Datos)
In the first expression, you're getting 31/07/2015 till 31/08/2015
Your month values are just text values, not dates or in any other way recognizable to qlikview as months. So you'll either have to turn those into something useful or use the Date field instead in an expression like Count({<Date={'>=$(=monthstart(today(),-1))<$(=monthstart(today()))'},Datos={">0"}>} Datos).
Hi Gysbert,
Thank you for your reply,
Look with your anlysys I did this:
= Count({<Date={'>=$(=monthend(today(),-1))<$(=monthend(today()))'},Datos={">0"}>} Datos)
But the final result gives 18...
it is assumed that the value must give 17
What I want is the sum of August and average
You can check August here (the page is in spanish sorry about that)
Hi,
Just need to change the set analysis
= Count({<Date={'>=$(=monthend(today(),-1))<$(=monthend(today()))'},Datos={">0"}>} Datos)
to this
= Count({<Date={'>$(=monthend(today(),-1))<$(=monthend(today()))'},Datos={">0"}>} Datos)
In the first expression, you're getting 31/07/2015 till 31/08/2015
Thank you very very much!