This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a problem with dates. I use an applymap to get the correct date in a table.
applymap (temp, orderdate) AS date.
However, the date will be shown as follows: 19-20-2017 00:03:04. Now I want something like 43123 or 43124. Any idea how I can convert this with an applymap?
Thanks in advance!
applymap (temp, num(orderdate)) AS date
View solution in original post
May be try this
Floor(ApplyMap('temp', orderdate)) as date.
you could use num also here
Num(ApplyMap('temp', orderdate)) as date
thanks all! it all worked out!