topic Re: Comparing two fields using selection box in QlikView

Comparing two fields using selection box

Anonymous — Fri, 30 Oct 2015 02:10:08 GMT

Hello,

I am aiming to compare columns of data using a selection box to see if the fields have changed. I want 5 years (e.g. 2010, 2011, 2012, 2013 and 2014) of fields and want the user to compare any two fields to see if a record changed between them.

Could someone please help me with the syntax for such a selection box.

Thank you.

Re: Comparing two fields using selection box

sumitjadhav — Mon, 02 Nov 2015 11:54:46 GMT

hello tyler Gregory,

I didnt understood ,what you exactly want ,pleaase explain it in brief with some data.

Re: Comparing two fields using selection box

vishsaggi — Mon, 02 Nov 2015 12:00:40 GMT

Hello Tyler,

I believe you are looking for Alternate State analysis here for comparing the values.
Can you explain little more or attach some sample data or output for further help.

Thanks,
V.

Re: Comparing two fields using selection box

Anonymous — Mon, 02 Nov 2015 12:14:12 GMT

When It comes to Compare..

Alternate states are the best option. You can create two states & keep the object as per your requirement into state.

Re: Comparing two fields using selection box

jafari_ervin — Mon, 02 Nov 2015 14:16:52 GMT

you should create two list box with two different state

Create Alternate state from Setting ->Document Properties -> General Tab

and set state from object general tab.

Re: Comparing two fields using selection box

Anonymous — Mon, 02 Nov 2015 17:14:34 GMT

Hi,

That is exactly what I want to do. Here is an example:

Date # 1 Date # 2

Free Shipping Flag Y N

I want to have list boxes for the fields 'Date #1' and 'Date #2' above so that the user can select the dates they want to compare.

If the field changed from one date to another, I want the latest record to be displayed.

I want to exclude all records that have an entry in one data set but not the other (i.e. if a product was not around for Date #1 but was added in date #2, I do not want this to be displayed). I only want it to display a change if the record was present in both data sets.

Please let me know your thoughts.

Thank you!

Tyler

Re: Comparing two fields using selection box

miguelbraga — Mon, 02 Nov 2015 17:30:07 GMT

Hi Tyler,

Can you kindly share a qvw sample so that we can solve your problem? Or can share a excel or csv file with your dates?

Regards,

Re: Comparing two fields using selection box

Anonymous — Mon, 02 Nov 2015 17:57:50 GMT

I have included an Excel file below that displays a sample input file and the output I am trying to achieve.

Please let me know if you are able to help or if you have further questions.

Thank you!