6 Replies Latest reply: Mar 1, 2015 9:33 AM by Nir Katz RSS

    Merge two fields and sow as one dimension

    rohit gharat

      i have two fields for Eg. STATE and CITY. In pivot table i take two fields as dimension displaying in seerate column but i want to show it as single column only.

      Location
      Statecity
      maharashtramumbai

        As seen in above table STATE and City are two fields of table and LOCATION is the column name i.e single column i have to show in pivot table i am suppose to display..

      how to do this in qlikview ...Please do help..Your help would be apppreciated !!!!