topic percentage in QlikView

percentage

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

i have a text box

in which i have wriiten the code as below fro getting duplicate groups

=Count(Aggr(If(Count(GROUP_NAME) > 1,GROUP_NAME),GROUP_NAME))

now i want the percentge of that, how to do in text box

sunny_talwar — Tue, 05 Jun 2018 11:20:40 GMT

May be this

Num(Count(DISTINCT {<GROUP_NAME = {"=Count(GROUP_NAME) > 1"}>} GROUP_NAME)/Count(DISTINCT GROUP_NAME), '##.0%')

qlikapple — Tue, 05 Jun 2018 11:29:49 GMT

please its urgent , can anyone help

sunny_talwar — Tue, 05 Jun 2018 11:31:08 GMT

Are you not seeing my response above?

jyothish8807 — Tue, 05 Jun 2018 12:09:25 GMT

Try this:

num(Count(Aggr(If(Count(GROUP_NAME) > 1,GROUP_NAME),GROUP_NAME))

count({1}GROUP_NAME),'##.0%')

Br,