Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Label for ranking in text box

Hello Community,

I'm wondering how to make the below equation on my dashboard just a simple integer.  Right now, it displays the HouseHold.ReportingTeam and then the integer, like "Example Team3" [sic].  The point of the text box is to rank the HouseHold.ReportingTeams, if that matters.  However, I've already got a header on top of the text box, so I don't need a repeat of the "Example Team" part.  How do I get rid of it without changing the ranking?

Thanks!

Ben

--------------

Num(rank(Count({ <HouseHold.InceptionDateFlag={1}, HouseHoldIntroHeld.IsCanceled={0}, HouseHoldIntroHeld.IsNoShow={0} > } DISTINCT HouseHoldIntroHeld.WEGAccountNumber))

/

Num(Count({ <HouseHoldIntroHeld.IsCanceled={0},HouseHoldIntroHeld.IsNoShow={0}> } DISTINCT HouseHoldIntroHeld.WEGAccountNumber))*100,

HouseHold.ReportingTeam)