2 Replies Latest reply: Jan 19, 2017 11:47 PM by ShyamSundar Raghavendran RSS

    Issue with RowNo() - QlikSense

    ShyamSundar Raghavendran

      Dear Experts,

       

      Trying to use a radar chart - extension in Qliksense with the below components.

       

      I have 2 dimension KPI,Country and one measure ( Sum ({<Filter to select common KPIs among the 2 selected countries>}Values)) in a radar extension object.

       

      Requirement is to show the sequential numbers for the KPI_NAMES instead of the name.

       

      When i used Rowno()  / RowNo(TOTAL), it gives me some numbers - but not sequential because of the filters at the expression I believe.

       

      Tried using AGGR(RowNo(),KPI_NAME) - because I need to have the the sequential rownos as the dimension - but the expression has to evaluate for KPI_NAMe.

       

      Kindly help - i have been sitting on this for hours together.

       

      Thanks