Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Double record in table box

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.

Screen1.JPGIndicatorOK.JPG

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

Thanks.

Claudiu

1 Solution

Accepted Solutions
Not applicable
Author

I think I figure it out. I put the expression in the same table with the cases. And now it is ok.

screen2.JPG

Before it was on a different table.

Thanks a lot to all of you!

View solution in original post

15 Replies
parthakk
Creator II
Creator II

Hi,

Can u attach sample excel file?

Thanks,

Partha Kulkarni

Not applicable
Author

Hi,

I've attached the excel file required.

Thanks,

Claudiu

tresesco
MVP
MVP

A sample qvw that shows the issue would be helpful.

parthakk
Creator II
Creator II

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

Not applicable
Author

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

Not applicable
Author

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
Specialist
Specialist

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

11.PNG22.PNG

Not applicable
Author

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

qlikmsg4u
Specialist
Specialist

Attach your file to look into the problem.