IF AND Calculation

[HereWeGoAgain]

Good Day

Please assist with the following:

I would like to create an IF statement:

If([POD's Older Than]>=7 AND If([POD's Older Than]<=13),1,0)

I want it to kick out a "1", if the value is between 7 and 13 and ignore the rest.

[agigliotti]

Hi @HereWeGoAgain ,

Please use the below expression:

If( [POD's Older Than]>=7 AND [POD's Older Than]<=13, 1, 0 )

Best Regards

[HereWeGoAgain]

@agigliotti @tresesco 

Tried both "missing right parenthesis"

[tresesco]

Issue couldn't be identified from the screen shot. Are you using master item? Could you share your sample app?

[HereWeGoAgain]

Hi, i'm new with Qlick i'm not sure what you are referring to.

below is the field that it should be calculating from.

LoadDebriefedFlag='N'  -- Means that paperwork has not yet been received, then i basically want to calculate how long the paperwork has been outstanding, Older than 7/14/21 Days

Hope this answers your question

[HereWeGoAgain]

@tresesco please let me know what you would like me to share

[tresesco]

sample app what you have been working on (may be), i.e. - the .qvf (qlik sense application)

[HereWeGoAgain]

I'm connected to a QVD where all our data is stored, hope this helps. I'm very new so you will need to dumb-down it for me