Qlik Community

App Development

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

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simon20
Partner
Partner

Display dynamic dimension movement per ID over time?

I am currently working with a monthly snapshot customer data table, basically looking like this

IDDateDim1
1202001A
1202002B
1202003B

 

What I need to achieve is some way to, on an ID level, see Dim1 movement over time. I visualize it like this:

  • One filter/variable where you set interval in months (>0). Note! I don't want to select a start point for the interval, so if no date selections is made it should compare all Dates with Date + X months.
  • Based on above selections, visualize a sankey chart (or similar), where:
    • Dimension 1: Dim1 at period in "Date" column
    • Dimension 2: Dim2 at period in "Date" column + filter/variable selection
    • Measure: Distinct ID count

To visualize it in a table, it would look something like this

Dim1 @dateDim1 @date + XAmount
AA3
AB2
BA5
BB7

 

Optimally, I want to handle this in-app. The app has other flags and dimensions, and I am afraid that handling this in script would explode the row count.

 

0 Replies