topic Re: If Else Statements in QlikView

If Else Statements

yrstruly — Sat, 16 Nov 2024 05:07:27 GMT

Can somebody please assist me please?
I need to do an If Else statement or something simialar for this:

Display the total of "AUTHORISED AMOUNT" for all claims of which the "INCIDENT DATE" fell within the date range of each
Catastrophy start and end date (Excel Document 'Catastrophy Incidents'). If the "AUTHORISED AMOUNT" is R0, use the field "CLAIMED AMOUNT" as a value.
For this view, you should only include claims where the CLAIM STATUS is not equal to 'R' or 'Z'.

Use the Claims data to provide useful views.

-----------------------------

Please see: https://drive.google.com/open?id=1wk7AUNXITIsrzoY6uDgMxMFrvc-dO7n3 … AND https://drive.google.com/open?id=1Bdq0jxJ0g5cXg2jK_1YjUlr-josKXnkD …

Re: If Else Statements

overclocked — Wed, 28 Nov 2018 08:08:49 GMT

can you post a sample data?

Re: If Else Statements

yrstruly — Wed, 28 Nov 2018 08:29:17 GMT

Please see: https://drive.google.com/open?id=1wk7AUNXITIsrzoY6uDgMxMFrvc-dO7n3 … AND https://drive.google.com/open?id=1Bdq0jxJ0g5cXg2jK_1YjUlr-josKXnkD …

Re: If Else Statements

overclocked — Wed, 28 Nov 2018 08:41:20 GMT

Error 404 the requested url was not found

Re: If Else Statements

yrstruly — Wed, 28 Nov 2018 09:08:39 GMT

https://drive.google.com/file/d/1W3y3RBT6b5PHxTyVzZiGviyTDynE8At0/view?usp=drivesdk ------@@@@
https://drive.google.com/file/d/1wk7AUNXITIsrzoY6uDgMxMFrvc-dO7n3/view?usp=drivesdk

Re: If Else Statements

yrstruly — Wed, 28 Nov 2018 15:11:43 GMT

and?

Re: If Else Statements

overclocked — Wed, 28 Nov 2018 23:51:46 GMT

try this

SUM(if(timestamp#([incident date])>=Timestamp#([Start Date]) and timestamp#([incident date])<=TimeStamp#([End Date])

and [Authorized Amount] > 0, Authorized Amount] ,

if(timestamp#([incident date])>=Timestamp#([Start Date]) and timestamp#([incident date])<=TimeStamp#([End Date])

and [Authorized Amount] =0,[Claimed Amount])))

Re: If Else Statements

yrstruly — Thu, 29 Nov 2018 13:06:13 GMT

This is what i get, what am i doing wrong?