Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
coming off from this discussion I have a problem with the following expression:
(Sum({$<Year={"(=Year(Today()))"}>}Kosten)+Sum({$<Year={"(=Year(Today()))"}>}Materialeinkauf))
/(Sum({$<Year={"(=Year(Today()))"}>}[Erlös])+Sum({$<Year={"(=Year(Today()))"}>}Schlussrechnung))
As far my knowledge goes, the "$" shall make shure, that just the period of the current year is considered. But it shows the value of the whole data. Furthermore I can change the expression (Year(Today)) to anything else, but nothing happens with the value. Any idea what I did wrong with my formula?
Thanks in previous for the help.
and do u have a field called Year?? make sure it's Year not year; cause qlik in case sensitive !
I see that your Year is blue (which is the color of a function, if qlik was interpreting ur Year as a field, it should be kind of orange !
try as follow:
(Sum({$<Year={"$(=Year(Today()))"}>}Kosten)+Sum({$<Year={"$(=Year(Today()))"}>}Materialeinkauf))
/(Sum({$<Year={"$(=Year(Today()))"}>}[Erlös])+Sum({$<Year={"$(=Year(Today()))"}>}Schlussrechnung))
Year(Today()) is a function so it needs an "=" sign:
=Year(Today())
when we have a '=' we add the $ (before each calculation) : $(=Year(Today()) ) => this is 2018
Hallo Tom,
ändere die Formel in
(Sum({$<Year={$(=Year(Today()))}>}Kosten)+Sum({$<Year={$(=Year(Today()))}>}Materialeinkauf))
/(Sum({$<Year={$(=Year(Today()))}>}[Erlös])+Sum({$<Year={$(=Year(Today()))}>}Schlussrechnung))
Gruss
Martin
Thanks for the answers, unfortunately the described behaviour is shown furthermore. I myself can't really explain why the term is ignored, do I have to define "Year" or "Today" in any furhter way?
why have u deleted the double quotes?
try with the double quotes as u were doing
Year field is a text or number/date? there is only explanation i can see for this to not work
and do u have a field called Year?? make sure it's Year not year; cause qlik in case sensitive !
I see that your Year is blue (which is the color of a function, if qlik was interpreting ur Year as a field, it should be kind of orange !
i have provided him the solution in Express KPI of Year (Today) . Omar Please check the thread once.
I tried it the way you mentioned as the way Martin Pohl showd, both ways lead to the same mistake as described.
to check that the result in set Analysis is ok do:
put your expression into a table.
use any dimension that the table Chart is show values.
don't label the expression!!
Export values to Excel.
There you can see that expression Year=year(today()) is changed into Year = 2017