Double record in table box

[#1]

Hello,

I have an issue regarding a table box.

Basically, my application should calculate KPI for some Salesforce cases, and every case should have Indicator OK, or NOK based on this formula : 'if(ComplitionDate <= TargetDate, 'OK', 'NOK')' , but there are some cases which has both values, OK and NOK.

Why is happening this ? And if I create a chart, the result is '-', like there are more than 1 value.

But if I put this formula in a text box, the result is 'OK'.

First I thought that a case has more than one Target Date or CompletionDate, but no. It has only one date.

See the screenshots.

Can you tell me why is this happening ? And any ideas how to fix this ?

Thanks.

Claudiu

[parthakk]

Hi,

Can u attach sample excel file?

Thanks,

Partha Kulkarni

[#3]

Hi,

I've attached the excel file required.

Thanks,

Claudiu

[tresesco]

A sample qvw that shows the issue would be helpful.

[parthakk]

Hi,

I used the same condition in script as

if(CompletionDate<=TargetDate,'OK','NOK') as Indicator

and it seems working fine.. We shall have only value OK associated with it. Is it what u were expecting?

Thanks,

Partha Kulkarni

[#6]

I've updated the post with a sample qvw. Hope to be helpful.

[#7]

Yes. It is what I expect. I've created a chart and pus the condition in the chart and I have only one values (which is ok). But I need a table box because a case can have more than one Milestone Type, (resolution 1, 2,3 response, etc) and I need a value in the table for each Milestone.

[qlikmsg4u]

Here i got value as OK, i used same expression.

[#9]

You load the data from the excel sample. But why is not working on my script ?

[qlikmsg4u]

Attach your file to look into the problem.