topic Re: Add days to a month in QlikView

Add days to a month

Wed, 25 Nov 2020 16:16:04 GMT

How can I split a month into half ( first half, second half) . I was actually looking for an expression, where I can split my metrics into tiers based on the following criteria

1) usage date <= activation month + 15 days.

2) usage date > activation month + 15 days and usage date <= activation month + 45 days

3) usage data > activation month + 45 days and usage date <= activation month + 75 days

Re: Add days to a month

tyagishaila — Wed, 27 Jul 2016 09:45:44 GMT

Do you have month field or Date field.

Re: Add days to a month

Wed, 27 Jul 2016 09:53:16 GMT

Hi Tyagishaila,

I have date filed for usage and month field for activations.

Re: Add days to a month

sunny_talwar — Wed, 27 Jul 2016 10:05:38 GMT

May be like this:

LOAD [usage date],

[activation month],

If([usage date] - [activation month] <= 15, Dual('Tier 1', 1),

If([usage date] - [activation month] <= 45, Dual('Tier 2', 2),

If([usage date] - [activation month] <= 75, Dual('Tier 3', 3)))) as Tiers

Re: Add days to a month

tyagishaila — Wed, 27 Jul 2016 10:23:55 GMT

Have you get solution in Sunny T's reply ?

Re: Add days to a month

kkkumar82 — Wed, 27 Jul 2016 10:25:16 GMT

If you want to have a date flag showing first half and second half create a flag in the edit script as

if(Day(Date)<= 15,'First Half','Second Half') as DaysFlag

Also keep in minds months with 30,31,28,29 days in the if condition