20 Replies Latest reply: Feb 25, 2016 5:19 AM by Shyamala Mahendran RSS

    grouping qlikview

    Shyamala Mahendran

      sample data for grouping.png

       

      Expressions

      = fractile(Value1,.5)

      =fractile (Value 2,.5)

      =fractile(if(Country= India, Value1),.5)

      =fractile(if(Country= India, Value2),.5)

      i want to group 1,2 together and 3, 4 together it should look like

       

      bsample.png