Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
612118513
Contributor II
Contributor II

Compare two different Excel files

Hi Everyone

I´m new in this Qlik view world, and i want to learn a lot

Someone can help me with the next question?

From my daily Job I recieve an Excel file that contains a lot of information, there is column call "Customer Summary Status" that contains 9 posible values from a dropdown list.

Is posible charge two excel files, one from today´s information and second from yesterday´s information and compare what values Change? could be in a table box?

The dropdown list contains a value "Customer Holds", i want to detect which register from the column "Customer Summary Status" in yesterday file had whatever value and today has "Customer Holds",   and  also detect which value yesterday had "Customer Holds" and today have another one.

I hope can be clear my requierment, if no please feel free to make all the questions that can make it clear.

Thanks my friends

0 Replies