Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I want to express the sum of external services per revenue of the current year. The external services is defined by (Kosten + Materialeinkauf), the revenue is defined by (Erlös + Schlussrechnung).
I use the following formula:
But the result stays -, so there must be a mistake. Can anyone spot what I did wrong?
Thank you.
Regards
Tom Müller
You're right, there was a mistake. But it's not the solution, furthermore the formula equals to (((Sum(Kosten)+Sum(Materialeinkauf))/((Sum(([Erlös]))+Sum(Schlussrechnung))))).
What I could find out is, that the perimeter Year(Today()) is ignored, as I can change today to any other word, but nothing happens.
As per my understanding it should work. may be i am missing something .
stalwar1 may help you.
Will check in a bit
Don't see any obvious mistakes in this expression
=(Sum({1<Year = {"$(=Year(Today()))"}>} Kosten) + Sum({1<Year = {"$(=Year(Today()))"}>} Materialeinkauf))
/(Sum({1<Year = {"$(=Year(Today()))"}>} [Erlös]) + Sum({1<Year = {"$(=Year(Today()))"}>} Schlussrechnung))
But I am going to ask few questions which may sound stupid, but are the problem a lot of the times
1) Do you have a field called Year? If not, are you replacing Year above with your Year field?
2) Qlik Sense has a auto generated calendar, is your field auto generated year field? If it is, the set analysis might not work on those fields
Derived fields not working in Set Analysis To fix this, create a new field in the script
3) Is Year field linked to everything else in your database? If isn't, then set analysis can't really do anything