topic Re: Dynamically Change Date in QlikView

Dynamically Change Date

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

let's assume I have a date '03-11-2015' as start date.

Now I want to write a logic

if start date is less than '01-01-2017'

then

start date = '01-01-2017'

else

don't change the start date.

pls assist.

Re: Dynamically Change Date

maxgro — Mon, 24 Jul 2017 16:11:30 GMT

Date(RangeMax( date#('03-11-2015', 'DD-MM-YYYY'), MakeDate(2017)))

Date(RangeMax( date#(StartDate, 'DD-MM-YYYY'), MakeDate(2017)))

Re: Dynamically Change Date

Mon, 24 Jul 2017 16:24:59 GMT

I am new to Qlikview. Can you pls share the exact condition.

Re: Dynamically Change Date

ahaahaaha — Tue, 25 Jul 2017 12:14:37 GMT

Hi,

May be like this?

If([start date] < '01-01-2017', '01-01-2017', [start date]) as [start date]

Re: Dynamically Change Date

vishsaggi — Tue, 25 Jul 2017 12:33:36 GMT

What Massimo expression does is below:

Reference: QV Ref Guide.

rangemax(expr1 [ , expr2, ... exprN ])

Returns the highest numeric values found within a range of 1 to N arguments. If no numeric value is found, NULL is returned.

RangeMax(Date#('03-11-2015', 'DD-MM-YYYY')) = This will return 42311

RangeMax(MakeDate(2017)) = This will return 42736

So out of these two numbers It will pick the max number which is 42736 which is 01-01-2017.

So Date(RangeMax(Date#('03-11-2015', 'DD-MM-YYYY'), MakeDate(2017))) - Will return 01-01-2017

For eg: IF your start date is like 15-03-2017.

RangeMax(Date#('15-11-2017', 'DD-MM-YYYY') ) will return 42809 which is greater than 42736 so the start date will be Date(42809) which is '15-11-2017'.

Hope this gives you some clear idea.