Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

charliea
New Contributor

Comparing data

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.

4 Replies
rsvebeck
Valued Contributor

Re: Comparing data

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

ahaahaaha
Honored Contributor

Re: Comparing data

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

charliea
New Contributor

Re: Comparing data

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

charliea
New Contributor

Re: Comparing data

Here is an exemple of what I would like.

I load my data to obtain the table below:

DateProjectStatusValueDeadline
08/05/2017001B1000

31/10/2017

08/05/2017002C200031/10/2017
15/05/2017001B100031/12/2017
15/05/2017002D200031/10/2017
15/05/2017003A300031/10/2017
15/05/2017004A50031/12/2017
22/05/2017001C150031/12/2017
22/05/2017003A300031/12/2017
22/05/2017004A30031/12/2017
22/05/2017005A100031/12/2017

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

  • New project
ProjectStatusValueDeadline
005A1000

31/12/2017

  • Canceled project
ProjectStatusValueDeadline
002D200031/10/2017

  • Status change
ProjectStatus
001C

  • Value change
ProjectValue
0011500
004300

  • Deadline change
ProjectDeadline
00331/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

Community Browser