Re: count repeated value - Page 3 - Qlik Community

sagarrahul · ‎2016-06-17

hii need a help

just tell me how to count repeated value in below table .

ICD_CODE_LEVEL1_org

N41.0

R50.9

B54

S82.1

B54

plesase help me in this

maniram23 · ‎2016-06-20

Hi,

You can try this like.

You can take this field "ICD_CODE_LEVEL1_org" in one list box .

There you can select "Show frequency " Option .

Then you know your data how many repeated.

sagarrahul · ‎2016-06-20

its not working

PrashantSangle · ‎2016-06-20

Hi,

where this value come from, If you want the output which you said above.

You can achieve it in list box

select field in list box and check show frequency from list box property > general tab

or

add expression count(fieldName)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

sagarrahul · ‎2016-06-20

max but i want it in my table