7 Replies Latest reply: Jun 1, 2017 8:42 AM by beck bakytbek RSS

    cross table in Qlik Sense

    beck bakytbek

      Hi Folks,

       

      my situation does look like: i have this table:

      Produc, Month, Sales

      A, Jan 2017, 10

      A, Mar 2017, 20

      A, Apr 2017, 30

      B, Mai 2017, 40

      B, Jun 2017, 50

       

      i want to convert this table into following table:

       

      Product, Jan 2017, Mar 2017, Apr 2017, Mai 2017, Jun 2017

      A,          10               20          30                0           0

      B            0                  0           0               40          50

       

      Does have anybody any idea?

      Thanks a lot for your feedback and help

       

      Beck