topic Re: Timeframe feature in App Development

Timeframe feature

thakurj — Tue, 22 Aug 2023 08:22:51 GMT

I need to develop a timeframe feature in an app. The feature needs to be used as a dimension in line charts and bar charts.

The base dimension for this feature is a date field. The feature should allow the dimension to be changed from Year, to quarter, month, week and day.

The feature needs to be present in the form of a slider so that the user can choose dimension in forward as well as backward direction. The chart using the Timeframe as a dimension should display all levels of hierarchy for the date as per the selection made by the user.

Could someone please help

Re: Timeframe feature

Or — Tue, 22 Aug 2023 09:05:32 GMT

This seems far outside the bounds of anything that exists within the native app, so you'll likely need to develop your own extension for this.

https://help.qlik.com/en-US/sense-developer/May2023/Subsystems/Extensions/Content/Sense_Extensions/extensions-getting-started.htm

Re: Timeframe feature

thakurj — Fri, 25 Aug 2023 03:32:42 GMT

Hi,

Is there a way to build something similar? Maybe some kind of a workaround using master calendar or something?

Re: Timeframe feature

marcus_sommer — Fri, 25 Aug 2023 13:32:50 GMT

I think everything is already there - at least to provide the mentioned information. In regard to the layout and the user-experience you might be not able to get a 1:1 replication but it mustn't be worse else it might be even better.

The common approach for such scenarios is to use dimension-groups. In QlikView are cyclic- and drill-groups native available but in Sense AFAIK only the drill-group (but there are also workarounds to emulate cycling-groups).

Beside this the object-dimensions could be also controlled per variables or selections, for example by using an island-table for the navigation like:

t: load pick(recno(), 'Year', 'Month', 'Week') as Period autogenerate 3;

which is then provided within a list-box and the dimensions of the charts and/or appropriate selection list-box for the period-values is then simply:

$(=maxstring(Period))

Re: Timeframe feature

thakurj — Wed, 30 Aug 2023 04:47:51 GMT

Hi @marcus_sommer
Could you please let me know the workaround to emulate cyclic groups in Qlik sense?

I have tried the drill down approach but it doesnt exactly work. The dimension needs to be a bit of both honestly. Cyclic as well as drill down.
Any help would be appreciated.

Re: Timeframe feature

marcus_sommer — Wed, 30 Aug 2023 05:51:55 GMT

Here an example for a workaround:

https://community.qlik.com/t5/Qlik-Sense-Documents/Cyclic-Groups-in-Qlik-Sense/ta-p/1763172

which could be probably extended to get a mix and/or a nesting of dimension groups which are in no way native provided.