topic Re: set format in QlikView

set format

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a variable with hard coded but I want to be dynamic how can set this with the same format

Current Variable:

vToday==num(Timestamp#('08/31/2017 05:00:00','MM/DD/YYYY hh:mm:ss'))

so I need that date should dynamic

prma7799 — Thu, 28 Sep 2017 07:19:31 GMT

Like this??

vToday=num(Timestamp(Today(),'MM/DD/YYYY hh:mm:ss'))

its_anandrjs — Thu, 28 Sep 2017 07:24:05 GMT

Try this

=Num(Timestamp(Today(),'MM/DD/YYYY hh:mm:ss'))

its_anandrjs — Thu, 28 Sep 2017 07:25:43 GMT

Use NOW() in place of Today()

Let vToday =Num(Timestamp(Nowy(),'MM/DD/YYYY hh:mm:ss'));

soniasweety — Thu, 28 Sep 2017 09:21:25 GMT

not working

its_anandrjs — Thu, 28 Sep 2017 09:35:19 GMT

Sorry it is NOW()

Let vToday =Num(Timestamp(Now(),'MM/DD/YYYY hh:mm:ss'));

soniasweety — Thu, 28 Sep 2017 09:41:37 GMT

tried that still not working

prma7799 — Thu, 28 Sep 2017 09:43:13 GMT

Please share some sample file and expected output.

its_anandrjs — Thu, 28 Sep 2017 11:02:01 GMT

Ok try this with Floor or not required in the Num format than use timestamp

Let vToday = Floor(Timestamp(Now(),'MM/DD/YYYY hh:mm:ss'));

Let vToday1 = Timestamp(Now(),'MM/DD/YYYY hh:mm:ss');

See Attached