Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Re: Double record in table box

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
Highlighted
Creator II
Creator II

Re: Double record in table box

Hi,

Can u attach sample excel file?

Thanks,

Partha Kulkarni

Highlighted
Not applicable

Re: Double record in table box

Hi,

I've attached the excel file required.

Thanks,

Claudiu

Highlighted
MVP
MVP

Re: Double record in table box

A sample qvw that shows the issue would be helpful.

Highlighted
Creator II
Creator II

Re: Double record in table box

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

Highlighted
Not applicable

Re: Double record in table box

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

Highlighted
Not applicable

Re: Double record in table box

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.

Highlighted
Specialist
Specialist

Re: Double record in table box

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

11.PNG22.PNG

Highlighted
Not applicable

Re: Double record in table box

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

Highlighted
Specialist
Specialist

Re: Double record in table box

Attach your file to look into the problem.