Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
i have an issue on a format date between QlikView et QlikSense
This expression is considered like an number on Qlikview
MYdate=02/01/2019 00:00:00
year(MYdate)&num(month(MYdate),00)as MYdate
But on qliksense it's considered like a string.
so i can't reuse my code because it's not the same format
How can i format this Date into 201901 numeric format
Thank so lot
my issue is about use a trigger select a value in a field
the trigger on Qlikview is ok
The trigger on QLiksense is KO
='("202110"|"202111"|"202112")'
no selection at all on my field
Do not undersand
Hi
Seems like Mydate looks like a timestamp but not recognise as a timestamp
so first let's transform it to a timestamp :
timestamp#(Mydate,'DD/MM/YYYY hh:mm:ss')
then floor it as a date :
Date(floor(Timestamp#(Mydate, 'DD/MM/YYYY hh:mm:ss') ),'DD/MM/YYYY')
So regarding your mesure it will look like :
year(
Date(floor(Timestamp#(Mydate, 'DD/MM/YYYY hh:mm:ss') ),'DD/MM/YYYY')
)
&
num(month(
Date(floor(Timestamp#(Mydate, 'DD/MM/YYYY hh:mm:ss') ),'DD/MM/YYYY')
),00)
i had to modify the type of the trigger
select value on a fields =>KO
Select value matches search =OK
DO NOT UNDERSTAND
hello Bruno
My issue was raised , i only change the type of the trigger on an action...
SO my title issue was not good.
Thank for your return