Discussion Board for collaboration related to QlikView App Development.
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 ?
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?
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.