topic Re: How it works? in QlikView

How it works?

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

Hi all,

how below expression works? can anyone explain?

Num(if(month(today())>=2,date('06/02/'&year(today()),'dd/mm/yyyy'),date('06/02/'&year(today())-1,'dd/mm/yyyy')))

Thanks

Sony

Re: How it works?

stabben23 — Thu, 14 Dec 2017 12:25:17 GMT

Theoretical it will gives you a numeric value of a hardcoded date.

if this month if greater or Equal With february it gives you 06/02/2017, if not 06/02/2016.

Re: How it works?

Anil_Babu_Samineni — Thu, 14 Dec 2017 12:27:50 GMT

I believe this won't effect. It may show - because Month(Today()) always return String and String never resemblance with Number.

Re: How it works?

soniasweety — Thu, 14 Dec 2017 12:30:39 GMT

yes I am getting null

but I want to get month end from that

Re: How it works?

stabben23 — Thu, 14 Dec 2017 12:33:25 GMT

Where do you want it, in a textobject? and what do you want to see, explain the Logic.

Re: How it works?

Anil_Babu_Samineni — Thu, 14 Dec 2017 12:35:03 GMT

To clarify, This will work. But not really know for Which month you are going to have MonthEnd?

=if(Num(Month(today()))>=2,Date(MakeDate(year(today()), 02, 06),'DD/MM/YYYY'),Date(MakeDate(year(today())-1, 02, 06),'DD/MM/YYYY'))

Re: How it works?

tresB — Thu, 14 Dec 2017 12:40:27 GMT

Date() here might not be required that way. Could you explain what exactly you are trying to do? May be explain in plain English. I guess much simpler solution would be there.

Re: How it works?

soniasweety — Thu, 14 Dec 2017 12:41:09 GMT

its giving me result like below

0.00012394 something

Re: How it works?

Anil_Babu_Samineni — Thu, 14 Dec 2017 12:42:52 GMT

Never give like that

Re: How it works?

soniasweety — Thu, 14 Dec 2017 12:43:29 GMT

I want to use this as variable

that value should be a monthend

Re: How it works?

tresB — Thu, 14 Dec 2017 12:44:46 GMT

Which month end? What is the logic?

Re: How it works?

Ben_P — Fri, 15 Dec 2017 15:49:06 GMT

An easier way to get month end date is to calculate the first day of (month+1), and then subtract 1.

Re: How it works?

Peter_Cammaert — Fri, 15 Dec 2017 16:03:36 GMT

And what about the MonthEnd() function?

LET vMonthEnd = Date(Floor(MonthEnd(Today())), 'DD/MM/YYYY'); // Date part only

Best,

Peter