Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

percentage

hi

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

4 Replies
sunny_talwar

May be this

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

qlikapple
Creator
Creator
Author

please its urgent , can anyone help

sunny_talwar

Are you not seeing my response above?

jyothish8807
Master II
Master II

Try this:

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

/

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


Br,

KC

Best Regards,
KC