Hi all together,
I have two fields "Datum" and "Erlös_Datum" that I would like to combine to one dimension, as the content is the same (dates). Without combinations the two dimensions would be =Year([Datum_Erlös]) and =Year(Datum). Is there a possibility to build a single dimension out of these two?
Thanks for the help and best regards,
Solved! Go to Solution.
Let's say my two sources look like this.
I want to set one filter, where I can filter the month or year. For me it doens't work (I have no explanation why, but that's another question) to rename "Datum_Erlös" to "Datum" in the script.
to rename this field in the script:
DATUM_ERLOS as DATUM,
to filter the field DATUM (date) using it month you should make sure that this field is recognized as a date.
did you try Month(DATUM) to see what it gives ?
Yes I tried doing this, and it works when I do it without the rest of the data. But when all data is loaded and when I filter after month(Datum), there is no more data shown for my revenue. I actually too unaware of Qlik to know why this happens, so I am looking for another way to manage this problem.