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.