topic Re: Double record in table box in QlikView

Double record in table box

Wed, 02 Sep 2015 06:28:25 GMT

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

Re: Double record in table box

parthakk — Wed, 02 Sep 2015 06:34:08 GMT

Hi,

Can u attach sample excel file?

Thanks,

Partha Kulkarni

Re: Double record in table box

Wed, 02 Sep 2015 06:38:48 GMT

Hi,

I've attached the excel file required.

Thanks,

Claudiu

Re: Double record in table box

tresB — Wed, 02 Sep 2015 06:42:14 GMT

A sample qvw that shows the issue would be helpful.

Re: Double record in table box

parthakk — Wed, 02 Sep 2015 06:48:51 GMT

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

Re: Double record in table box

Wed, 02 Sep 2015 06:53:05 GMT

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

Re: Double record in table box

Wed, 02 Sep 2015 06:55:05 GMT

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.

Re: Double record in table box

qlikmsg4u — Wed, 02 Sep 2015 06:57:33 GMT

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

Re: Double record in table box

Wed, 02 Sep 2015 06:59:13 GMT

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

Re: Double record in table box

qlikmsg4u — Wed, 02 Sep 2015 07:00:59 GMT

Attach your file to look into the problem.

Re: Double record in table box

Wed, 02 Sep 2015 07:02:54 GMT

I've attached a sample qvw in the main post.

Re: Double record in table box

parthakk — Wed, 02 Sep 2015 07:06:40 GMT

Hi,

You have one completion date LESS than target date and one completion date MORE than target date for same case number.. So you are getting both OK and NOK but the sample excel file you have both completion dates less than target date.

Thanks,

Partha Kulkarni

Re: Double record in table box

tresB — Wed, 02 Sep 2015 07:06:41 GMT

I see multiple target dates against the casenumber. And multiple dates would create a comparison return null in the text box resulting 'NOK'.

Re: Double record in table box

sunny_talwar — Wed, 02 Sep 2015 07:10:15 GMT

May be do a comparison against firstsortedvalue:

if(ComplitionDate <= FirstSortedValue(TargetDate, -TargetDate), 'OK', 'NOK')

Re: Double record in table box

Wed, 02 Sep 2015 07:15:13 GMT

There is one completion date less, but is not on Response 2, it is on Resolution 2. My example is only for Response 2. And on Resolution 2 there is no completion date and it is the same issue, I have OK and NOK values.

Re: Double record in table box

Wed, 02 Sep 2015 07:20:48 GMT

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

Before it was on a different table.

Thanks a lot to all of you!