Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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)

0 Replies