Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
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:
Project | Status | Value | Deadline |
---|---|---|---|
005 | A | 1000 | 31/12/2017 |
Project | Status | Value | Deadline |
---|---|---|---|
002 | D | 2000 | 31/10/2017 |
Project | Status |
---|---|
001 | C |
Project | Value |
---|---|
001 | 1500 |
004 | 300 |
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