topic Re: Field derive from Percentage based on the Date range in QlikView

Field derive from Percentage based on the Date range

Raggs — Mon, 21 Sep 2020 07:05:27 GMT

Hello Team,

I need to derive fields from percentage from date range fields. Please find the below given sample data

and, I need the out as below mentioned.

Can you please help me anyone on this ASAP.

Thanks in advance.

Raggs — Mon, 21 Sep 2020 07:12:09 GMT

I have used the below function however its not working

If(FromDate = '1/1/2019' and ToDate1 = '31/3/2019', Percentage, ) AS Percentage_1,

If(FromDate = '1/1/2019' and ToDate1 = '31/12/2019', Percentage) AS Percentage_2

Raggs — Mon, 21 Sep 2020 13:21:40 GMT

I got the answer for this.

thank u