2 Replies Latest reply: Dec 9, 2015 9:41 AM by Sangram Reddy RSS

    Expression help wildcard or value selection

    lakwinder singh

      Hi Guys,

       

      I'm not sure if this will make sense

       

      In this expression, can i use a wildcard where it says Dorset or something else, i want the result of one area value at a time when i qlik it rather than just hard code in Dorset.

       

      Thanks

       

       

      SUM({<AREA={"Dorset"}>}[Value])

      /

      SUM(TOTAL{<AREA={"*"}>}[Value])