Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
albertestrada
New Contributor II

QlikSense Sankey Diagram Help

Hello ,

I have three fields: Pattern / Month / Value

I would like to display thru Sankey Diagram a month over month movement in the Pattern. Therefore, the Sankey would have Two Dimensions: Pattern_-1 month and Pattern_Current Month

  • I can show Dimensions Pattern and Date as you see below, but I would prefer to only display Pattern prior month and Pattern current month.
  • I tried a set analysis for current month but did not work:   Aggr(Only({<Date={'04/01/2017'}>} Pattern ), Pattern)

Any guidance will be appreciated.