topic Validation Tab in QlikView

Validation Tab

Mon, 03 Jan 2011 11:43:33 GMT

Hi,

In one of my application I want to any objects to this tab that will help with validating data\spotting any discrepancies.

For example: For some the services, service group has not yet been mapped.

I want to highlights SERVICE values that do not have a corresponding mapping in Service Group Name.

Any suggestions how can I do this!

Validation Tab

prieper — Mon, 03 Jan 2011 22:42:46 GMT

With regards to mapping-tables I always prefer to work with OTHERSYMBOL-function with a script like the below:

SET OtherSymbol = +;
MainTable: LOAD * FROM .....;
ServiceName: LEFT KEEP (MainTable) LOAD ServiceID, ServiceName FROM ....;
MissingService: LOAD * INLINE [ ServiceID, ServiceName
 +, #N/A];

Doing so you may select #N/A (or any other text) in order to show all entries, for which there is not Service-Code mapped.

HTH
Peter

Validation Tab

Tue, 04 Jan 2011 06:17:23 GMT

Hi Peter,

Thanks for your help. I don't know how to implement this but I will try to implement and let you know the outcome if I am able to implement the same.

Validation Tab

Tue, 04 Jan 2011 07:21:27 GMT

Hi Peter,

Can you please suggest something which I can do it in the QV side instead of doing it in the script side. Please check with that and let me know.

Validation Tab

prieper — Tue, 04 Jan 2011 21:14:55 GMT

Think that it is preferable to have this as a real dimension in the script, but you may always use a calculated expression, see the attached file

HTH
Peter

Validation Tab

Wed, 05 Jan 2011 08:43:33 GMT

Hi Peter,

Thanks!

What you have provided was simple and useful. Do let me know if you have any other suggestions.