topic Re: Need Consistent data in QlikView

Need Consistent data

Mon, 21 Mar 2016 19:56:45 GMT

I have two files with same data(few fields).But both don't have same hierarchy.I want to make it hierarchy consistent and if any different values are there then I need to highlight the difference.

File1 :

field1 field2

A 11

B 22

C 33

D 44

file2:

field1 field2

A 11

B 22

C 33

D 55

D value should be highlight.Please help asap

Thanks

Re: Need Consistent data

Anonymous — Tue, 22 Mar 2016 05:24:04 GMT

try this....

Load your data using below script:

File1 :

LOAD * INLINE [

field1, field2

A, 11

B, 22

C, 33

D, 44]

;

QUALIFY field2 ;

file2:

NoConcatenate LOAD * INLINE [

field1, field2

A, 11

B, 22

C, 33

D, 55

];

Create one straight table use Field 1 as dimension

and expression will be:

1) only(field2)

2)only(file2.field2)

3)if(Column(1)=Column(2),'NO' ,'Yes')

in the background color of expressions and dimension use below code:

=if(Column(1)=Column(2),'NO',Green())

out put will be

Re: Need Consistent data

jagan — Tue, 22 Mar 2016 05:42:49 GMT

Hi,

Try like this

File1 :

LOAD * INLINE [

field1, field2

A, 11

B, 22

C, 33

D, 44]

;

File2:

NoConcatenate LOAD * INLINE [

field1, field2_File2

A, 11

B, 22

C, 33

D, 55

];

Chart :

Dimensions: field1, field2, field2_File2

Expression: if(field2=field2_File2,'Yes' ,'No')

Background Color expression: =If(Column(1)='NO',RGB(255, 0, 0))

Hope this helps you.

Regards,

Jagan.

Re: Need Consistent data

Digvijay_Singh — Tue, 22 Mar 2016 06:01:05 GMT

See if this can help based on front end changes -

Re: Need Consistent data

Mon, 28 Mar 2016 09:40:37 GMT

Thanks sandip

Re: Need Consistent data

Mon, 28 Mar 2016 09:41:34 GMT

Thanks Jagan

Re: Need Consistent data

Mon, 28 Mar 2016 09:42:29 GMT

Thanks Digvijay

Re: Need Consistent data

jagan — Tue, 05 Apr 2016 04:14:49 GMT

Hi,

If you got the answer close this thread by giving correct answer.

Regards,

jagan.

Re: Need Consistent data

Tue, 05 Apr 2016 09:06:49 GMT

No luck..Still looking for correct answer