Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yrstruly
Contributor
Contributor

If Else Statements

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 …
Labels (2)
7 Replies
overclocked
Contributor II
Contributor II

can you post a sample data?

overclocked
Contributor II
Contributor II

Error 404 the requested url was not found
yrstruly
Contributor
Contributor
Author

and?
overclocked
Contributor II
Contributor II

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])))

yrstruly
Contributor
Contributor
Author

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