Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
yrstruly
New 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
New Contributor II

Re: If Else Statements

can you post a sample data?

overclocked
New Contributor II

Re: If Else Statements

Error 404 the requested url was not found
yrstruly
New Contributor

Re: If Else Statements

and?
overclocked
New Contributor II

Re: If Else Statements

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
New Contributor

Re: If Else Statements

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