Validate the data using QV document

[qlikviewforum]

Hi,

I want to validate the data between the Hierarchy sheet and the mapping sheet in the attached excel.For example "Relaince Markets" which is there in the Level01 column in Hierarchy sheet exists in  "Report Level" column as "0(Zero)"(Level01-01=Level 0 in Report level). "XYZ" which is t here in the Level02 column in Hierarchy sheet exists in "Report Level" column as "1"(Level02-1=Level 1 in Report level) and so on.

I want to validate this using qlikview document. As explained above if the level are not matching between the Hierarchy sheet and Mapping sheet. It should highlighted in RED background. So that user can understand where the issue lies.

Can some one please share the sample document which does the samething as above. I'm unable start with this requirement.

Data attached with this excel is just a sample data to understand my requirement.

Thanks in advance

[qlikviewforum]

You are asking me to do something like this?

[qlikviewforum]

Can someone please help me out on this? It is little urgent!

[qlikviewforum]

TEMP:
CrossTable(Report_Level, Mapping)
LOAD View_Sort,

     Level01,

     Level02,

     Level03,

     Level04,

     Level05,

     Level06,

     Level07,

     Level08
FROM

[..\include\Hierarchy.xls]

(biff, embedded labels, header is 1 lines, table is [Hierarchy$]);



TMP:
NoConcatenate
load num(right(Report_Level,Len(Report_Level)-5)) as Report_Level_1,

        Mapping,

        View_Sort
Resident TEMP

;


drop table TEMP;

       

MAIN_TEMP:
LOAD Report_Level,

     Order,

     Mapping,

     Sample_Order
FROM

[..\include\Hierarchy.xls]

(biff, embedded labels, table is [Mapping$]);
left join(MAIN_TEMP)
load *
Resident TMP

;


drop table TMP;



MAIN:
load *,
if(num(Report_Level)-num(Report_Level_1)=1,1,0) as flag
Resident MAIN_TEMP

;


drop table MAIN_TEMP;

[qlikviewforum]

TMP:
NoConcatenate
load num(right(Report_Level,Len(Report_Level)-5)) as Report_Level_1,--Here it is
making numeric from the last digits..

        Mapping,

        View_Sort
Resident TEMP

;


drop table TEMP;

MAIN_TEMP:
LOAD Report_Level,

     Order,

     Mapping,

     Sample_Order
FROM

[..\include\Hierarchy.xls]

(biff, embedded labels, table is [Mapping$]);
left join(MAIN_TEMP)
load *
Resident TMP

;


drop table TMP;



MAIN:
load *,
if(num(Report_Level)-num(Report_Level_1)=1,1,0) as flag –Here it is
checking and updating the flag..
Resident MAIN_TEMP

;


drop table MAIN_TEMP;

[qlikviewforum]

Please find attachment