6 Replies Latest reply: Jun 3, 2016 12:46 AM by William Liang RSS

    How to conditional sum based on value in the first column

    William Liang

      Hello,

       

      I have a question regarding conditional sum based on values in the first column. Is it possible through qlikview and if so how should I structure the expression in pivot table.

       

      I have included a simplified example, the actual data set is more complicated therefore creating a new field of indicator would not be possible.

       

      Based on this table

      ProductCount
      Blue Jeans10
      White Shirt20
      Black Jeans30
      Blue Shirt40

       

      I am trying to do an aggregate like below through wildcard search based on the first column (e.g. for Blue  Sum all counts that matches wildcard *Blue* )

       

      ColorCount
      Blue50
      White20

       

      Thanks!!

       

      William