Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm getting crazy because - I guess - a small problem:
I import Data from a SQL-Database with OLE-DB - there is a data field (Date) with the format DD.MM.YYYY hh:mm.
My settings look like that:
SET TimeFormat='hh:mm';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm';
In another field a got some Entries per Month (SU_TIME) over 3 years.
Now I just want to show the average per month with AVG() and select one year as following:
AVG ({$<Date={2015}>}SU_TIME)
Dimenson is just Date.
The diagramm won't show any data to me.
Even simple if-statements do not work with Date ...
Hopefully you can help me!
Thanks a lot,
Jan
but if(Date>now(),..,..) should work - right?
No, It won't if Date has simple format and Now() returns Full timestamp. How come this works
You need to manipulate or play with Date format
Using separate year fields is absolutely common practice.
Nothing is faster than selecting a field directly (without wildcards) via set analysis.
So this "waste of space" you're thinking about is negligible, because QlikView stores only distinct values with the help of bit stuffed pointers...
All of your suggestions helped me a lot!
I firgured out as follows (in Script):
Year(Date) as Year,
Month(Date) as Month,