0 Replies Latest reply: Apr 24, 2017 5:16 PM by Albert Estrada RSS

    QlikSense Sankey Diagram Help

    Albert Estrada

      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.