5 Replies Latest reply: Jan 19, 2016 6:28 AM by Jonathan Dienst RSS

    Having several aggregations in pivot table.

      This is my example data:

       

      ID 1Param1

      Param2

      1

      32
      156
      237
      2410


      I want this (in form of a pivot table perhaps):


          |          param1        |       param2        |

      ----------------------------------------------------

      id | avg | min | max |   |  avg | min | max |

      ----------------------------------------------------

      1 |   4    |  3   |   5    |   |   4    |  2    |  6     |

      2 |   3.5 |  3   |   4    |   |   8.5 | 7     |  10   |

       

      Now I know I could do this (without the headers in pivot table 2 (param1, param2) by just creating measures with the aggr (min, max etc) but it will becomes very tedious when I have 10 parameters and 7 aggregations (min, max, median, avg, std, skew, count). Is there any simple way to make this automated? For instance, I just choose the parameter and it automatically creates 7 measures for the given parameter. Note, this concerns Qlik Sense.