topic Re: What if analysis. How to move values in time? in App Development

What if analysis. How to move values in time?

andy — Sat, 16 Nov 2024 20:54:42 GMT

Hi folks,

I would like to have your input on a challenge I'm facing. Normally what if analysis as shown by Qlik is just about scaling a measure. This is about "moving" values in the data like using addmonths() in the script answering what if we produce this order 1 month earlier and another 2 months later?

The users uses Qlik Sense today to look at current production planning and material demand.

Now they want to be able to move the individual projects in time, that is left and right on the x-axis in the chart below. Like Addmonths(startdate,offset) in the script but they want to be able to do this without having to wait for a scheduled task to reload the application. Also each user should see the original data all the time in the application not being influenced by some other user moving a project 3 months in time.

Any user who added an offset to a project shall be able to store that offset and retrieve it next time.

I've been thinking about

- on demand app generation (ODAG)

- extensions which modifies the underlying data-set so all charts are updated in a session

- mashups with crossfilter and own charts.

I attached a simple qvf to show how it could look like.

Any ideas are highly appreciated!

brgds

Andy

Re: What if analysis. How to move values in time?

sunny_talwar — Thu, 09 May 2019 11:16:38 GMT

Move all projects to a certain date or a select few? I am not sure I completely understand...

Re: What if analysis. How to move values in time?

andy — Thu, 09 May 2019 11:23:32 GMT

Hi,

Individually the projects shall be possible to move back and forth in time.

Lets say we want to see how it looks like if Proj C is started 2 months earlier than current plan and Proj E is started 3 months later.

Regards

Andy

Re: What if analysis. How to move values in time?

sunny_talwar — Thu, 09 May 2019 11:30:27 GMT

My knowledge of Qlik Sense is rather limited, but ODAG basically re-runs the dashboard, so I am not sure if that serves the purpose. But If you have limited number of projects, can you not use a variable offset for each of the project and adjust the timeline based on the user input. For instance they can enter -2 for Project C, if they want to adjust it to be starting 2 months earlier or 2 if they want to adjust it to be starting 2 months later

Re: What if analysis. How to move values in time?

andy — Thu, 09 May 2019 11:37:09 GMT

Well, I guess you cannot do that without a reload of the script...

Changing the x-axis of the chart will move all the projects.

Re: What if analysis. How to move values in time?

sunny_talwar — Thu, 09 May 2019 11:38:50 GMT

What can you not do without a reload? the variable option? I think variable can work for individual projects without a reload.

Re: What if analysis. How to move values in time?

andy — Thu, 09 May 2019 11:46:15 GMT

Sorry, I don't see how that should work.

Would you mind to modify the app or post another simple app to show how you would do that?

Re: What if analysis. How to move values in time?

sunny_talwar — Thu, 09 May 2019 12:19:31 GMT

Something like this

When vProjC is 0

When vProjC is -2

Does this make sense?

Re: What if analysis. How to move values in time?

andy — Thu, 09 May 2019 12:51:23 GMT

Hi,

That is a helpful suggestion, thanks!

It gets kind of weird when doing a selection though

Re: What if analysis. How to move values in time?

sunny_talwar — Thu, 09 May 2019 12:53:28 GMT

Right, what would you like to see when you make selection in YearMonth field?

Re: What if analysis. How to move values in time?

andy — Thu, 09 May 2019 13:02:45 GMT

I think the user would like to see the month selected also in the chart. Which seems impossible and might be a limitation they can live with.

How would you do when the number of projects change at every reload, need to dynamically assign the calculated dimension as well as the variables and the GUI-part...

I guess there will not be more than lets say 30 projects.

Re: What if analysis. How to move values in time?

sunny_talwar — Thu, 09 May 2019 13:31:23 GMT

For selection in YearMonth field... may be change it to a selection in a calculated filter dimension.

=Aggr(Only({1} AddMonths(YearMonth, Alt(Pick(Match(Project, 'Proj A', 'Proj B', 'Proj C', 'Proj D', 'Proj E', 'Proj F'), $(vProjA), $(vProjB), $(vProjC), $(vProjD), $(vProjE), $(vProjF)), 0))), Key)

Where Key is a field created by combining YearMonth and Project in the script

LOAD *, YearMonth&Project as Key;

For the changing Projects, you can dynamically create the variables in the script like this

FOR i = 1 to FieldValueCount('Project');

LET vFieldValue = FieldValue('ProjectWithoutSpaces', $(i));
LET $(vFieldValue) = 0;

NEXT

Now your chart dimension can be this

=Aggr(AddMonths(YearMonth, Alt(Pick(Match(ProjectWithoutSpaces, $(=Concat(DISTINCT Chr(39) & ProjectWithoutSpaces & Chr(39), ', '))), $(=Replace(Concat(DISTINCT '#(' & ProjectWithoutSpaces & ')', ', '), '#', '$'))), 0)), Project, YearMonth)

and filter dimension

Re: What if analysis. How to move values in time?

andy — Fri, 10 May 2019 07:59:30 GMT

Hi,

Thanks for your effort!

I think it works even better with your filtering-dimension used in the charts as well.

Any ideas how the automatically created variables shall be presented in the GUI to adapt for different number of variables in a nice manner? Create an extension perhaps...

brgds

Andy

Re: What if analysis. How to move values in time?

sunny_talwar — Fri, 10 May 2019 11:21:37 GMT

This is the part I am not sure about. May be instead of assigning customized variable, may be we create generic variable say v1, v2, v3 so that we can always have them with the same value. Will need to play around with the idea to get it to a point where you understand it's limitations, but yet work to some degree of satisfaction.

Re: What if analysis. How to move values in time?

andy — Mon, 13 May 2019 19:47:57 GMT

Hi Sunny,

I think you answered the question I asked so I'll mark it as answered.

Nice done!

My real case is somewhat more complicated though so maybe I'll go for a session app that is generated from the standard app after the user has selected his offsets anyway.

Thanks for your effort.

Regards

Andy