topic Re: Expression in QlikView

Expression

upaliwije — Thu, 23 Jul 2015 16:08:13 GMT

Hi,

I have following Fields in my data model

PR_Month

PD_month

Amount

I have written following expression in my pivot table but it is not working

SUM(IF(PR_Month<PD_month ,PROVISION_AMOUNT))

Pls correct me if I have written above expression incorrectly

Re: Expression

settu_periasamy — Thu, 23 Jul 2015 16:20:42 GMT

Hi,

Try this

SUM({<PR_Month={"<$(=PD_month)"}>}PROVISION_AMOUNT)

Re: Expression

sunny_talwar — Thu, 23 Jul 2015 16:24:12 GMT

Expression looks right to me. Create a table box with the three columns and see if the condition is ever true. If its not then you won't see any results.

Re: Expression

upaliwije — Thu, 23 Jul 2015 16:26:18 GMT

THANKS

Re: Expression

kmswetha — Thu, 23 Jul 2015 16:26:59 GMT

Hi Upali, Your expression looks good. did you check for syntax errors?