topic Blank records in source file in QlikView

Blank records in source file

Mon, 06 Dec 2010 08:29:41 GMT

Hi,

I have a dashboard with 3 tabs which is using excel as a source.There is one date field in the excel it should not be blank (as per the business requirements).

My requirement is if any blank records exists in the date field my dashboard should not refresh and it should show some error message saying that The date field is having blank records so dashboard board will not execute.

Any best suggestions to implement this.

Thanks,

Blank records in source file

prieper — Mon, 06 Dec 2010 10:20:45 GMT

Give it a try with a condition basing on COUNT-function, like

COUNT(IF(LEN(CriticalDateField) = 0, KeyField))

in order to show a text-field, show an error-message in the graph, hide the dashboard ....

HTH
Peter

Blank records in source file

Mon, 06 Dec 2010 11:01:17 GMT

I would also think about using an alert with the condition

COUNT(IF(LEN(CriticalDateField) = 0, KeyField)) <> 0

to send an email to whoever needs to resolve the issue, using 'On Post Reload' event when in batch mode.

Regards,

Gordon

Blank records in source file

Mon, 06 Dec 2010 12:47:59 GMT

Hi Gordon,

Could you pls let me know how to implement using this Alert function.

Thanks,