topic Re: Compare records in QlikView

Compare records

vlad_komarov — Fri, 28 Mar 2014 02:23:36 GMT

I have a Pivot table chart with 3 dimensions:

I need to find a way to compare records in B2 column between different FileDates (second dimension).

For example - display (highlight) records in column B2 for 7/18/2013 date that are not matching similar records for 11/18/2013 date.

Or create an expression that counts (and highlights) records from B2 Dimension for 7/18/2013 date that are not matching similar records for 11/18/2013 date

Any suggestions how to do that?

Regards,

Vladimir

Re: Compare records

tresB — Fri, 28 Mar 2014 04:44:07 GMT

Probably highlighting can be done using if statement as background expression of the dimension/expression. The counting would vary on presentation ( where/how you need that to be presented (text box/chart itself)). Share a sample qvw explaining your expected output there.

Re: Compare records

rwunderlich — Fri, 28 Mar 2014 04:44:20 GMT

Hi Vlad,

It's a matter of defining two sets and then doing set operations to find the intersection or difference. The easiest way to define the two sets is to use Alternate States and select a File Date in each state. See the attached example of something similar I did earlier.

-Rob

http://robwunderlich.com

Re: Compare records

vlad_komarov — Wed, 02 Apr 2014 03:43:37 GMT

Rob,

Thanks for the suggestion. This is exactly what I need.

Regards,

Vladimir