topic Re: Format Date change between QlikView/Qliksense in App Development

Format Date change between QlikView/Qliksense

ALEX1977ALEX — Wed, 02 Mar 2022 15:58:58 GMT

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

ALEX1977ALEX — Wed, 02 Mar 2022 16:15:49 GMT

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

ALEX1977ALEX — Wed, 02 Mar 2022 16:18:05 GMT

='("202110"|"202111"|"202112")'

no selection at all on my field

Do not undersand

brunobertels — Wed, 02 Mar 2022 16:22:21 GMT

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)

ALEX1977ALEX — Wed, 02 Mar 2022 16:41:12 GMT

i had to modify the type of the trigger

select value on a fields =>KO

Select value matches search =OK

DO NOT UNDERSTAND

ALEX1977ALEX — Wed, 02 Mar 2022 16:42:47 GMT

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