if condition

[dandaanilreddy]

Hello Qlik developers

I have 2 expressions i need to show the percentage if expression sum(actual) is greater than sum(company plan) the goal should be 100% if not it should display the percentage.

Can some one help me please

Thanks

Anil

[dandaanilreddy]

Hi Jason

Thanks for the reply. I have applied your expression but the result is same what i have achieved from sunny's expression. If actual is greater than company plan the goal should be 100%.

Thanks

Anil

[jcampbell474]

Sunny's expression probably encompasses more scenarios than mine, but both of them should work in the example you provided.

Using one row/record, give us an example of the value in these fields:

UnitActuals.ReceivedCasesFromProc: (what is your value)

UnitActuals.BudgetedCases: (what is your value)

[dandaanilreddy]

In the above screen shot for Jan 2015 the company plan target is 19365 but we have achieved actuals more than company plan then the goal result should be 100% instead of 4.62%

Thanks

Anil

[dandaanilreddy]

I have deleted the expression and recreated it. It's working now thanks.

Thanks

Anil