5 Replies Latest reply: Jun 6, 2017 4:09 AM by Andrey Khoronenko RSS

    Qlik Sense; Cross Table with multiple attributes.

    Neale Forth

      Hi QS Community,

       

      I am trying to create a cross table from the following data so I can build an area graph.

       

      Table Header: CRM#, StrikeRate, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4, etc

      Example data: 3333,  StrikeRate1, 1,2,3,4

       

      I need data to look like this ;

       

      3333, StrikeRate1, 2017-Q1, 1

      3333, StrikeRate1, 2017-Q2, 2

      3333, StrikeRate1, 2017-Q3, 3

      3333, StrikeRate1, 2017-Q4, 4

       

      I can't seem to be able to use the crosstable function with more than one attribute. Is this possible ?

       

      thanks

       

      Neale