topic Re: Comparing data in App Development

Comparing data

Anonymous — Wed, 17 May 2017 16:16:13 GMT

Hi,

I've a dataset of projects with their caracteristics wich is updated every week and I use it to show the evolution since the beginning of the year. The columns are the same every week but the number of project can change (projects added or deleted) and the values of each field can change too.

To load my data, I concatenate my table every week, and differenciate them with the date and the week number.

The next step is to be able to compare two weeks data and show those which has changed.

First to show in two tables the added projects and deleted projects.

Secondly to show projects with a value that has changed compared to last week. This comparison has to be done on every columns.

I have no idea of how to do that and hope someone will be able to help me.

Re: Comparing data

RSvebeck — Wed, 17 May 2017 21:25:00 GMT

With "Alternate States" you will be able to show two different date or week selections in one single chart, and then also show the differences between them.

Do you know how Alternate State works?

Robert

Re: Comparing data

ahaahaaha — Thu, 18 May 2017 11:38:43 GMT

Hi Charlie,

In the attached file ideas on the possible construction of your application. In the table "Change Volume Project" the data of the project parameter at the beginning of the week and the changes for the previous week are shown. The remaining figures should be clear from the contents of the charts. I hope this helps you something.

Regards,

Andrey

Re: Comparing data

Anonymous — Thu, 18 May 2017 15:48:14 GMT

Thanks to both of you, but it's the wrong location. I am using Qlik Sense and not Qlik View, my mistake, sorry. I move it in the right one.

But no I don't know Alternate State, is it existing in Qlik Sense too ?

Charlie

Re: Comparing data

Anonymous — Wed, 24 May 2017 14:33:03 GMT

Here is an exemple of what I would like.

I load my data to obtain the table below:

Date	Project	Status	Value	Deadline
08/05/2017	001	B	1000	31/10/2017
08/05/2017	002	C	2000	31/10/2017
15/05/2017	001	B	1000	31/12/2017
15/05/2017	002	D	2000	31/10/2017
15/05/2017	003	A	3000	31/10/2017
15/05/2017	004	A	500	31/12/2017
22/05/2017	001	C	1500	31/12/2017
22/05/2017	003	A	3000	31/12/2017
22/05/2017	004	A	300	31/12/2017
22/05/2017	005	A	1000	31/12/2017

I want to compare the data between 15/05 and 22/05 and represent:

New project

Project	Status	Value	Deadline
005	A	1000	31/12/2017

Canceled project

Project	Status	Value	Deadline
002	D	2000	31/10/2017

Status change

Project	Status
001	C

Value change

Project	Value
001	1500
004	300

Deadline change

Project	Deadline
003	31/12/2017

I want to be able to do that comparison between any week (08/05-15/05 and 08/05-22/05).

Do you have a solution (either in script or expression)?

Many thanks in advance.

Charlie