topic Re: Top 3 Reason Types in QlikView

Top 3 Reason Types

manojkulkarni — Wed, 12 Apr 2017 11:28:38 GMT

Hi Friends

Below is the table having case ID & Reason Type. We would require to calculate number occurrences of each reason type and show top 3 reasons as expected in the second table provided below.

Any suggestion or help is appreciated

Table1:

CaseID	Reason
449790	Q: Identify Payee
453917	Q: Vendor Refund
456423	Q: Identify Payee
456427	Q: Identify Payee
455388	Q: Identify Payee
455386	Q: Identify Payee
455361	Q: Advise on Allocation of Receipt
456900	Q: NonTenant check
453845	Q: Advise on Allocation of Receipt
456757	Q: Advise on Allocation of Receipt
456759	Q: Advise on Allocation of Receipt
456804	Q: Advise on Allocation of Receipt
456814	Q: Advise on Allocation of Receipt
456806	Q: Identify Payee
445595	Q: Advise on Allocation of Receipt
456783	Q: Advise on Allocation of Receipt
446283	Q: NonTenant check
453759	Q: Advise on Allocation of Receipt
455411	Q: Advise on Allocation of Receipt
456811	Q: Advise on Allocation of Receipt
456819	Q: Advise on Allocation of Receipt

Table2:

Reason	Occurance
Q: Advise on Allocation of Receipt	High
Q: Identify Payee	Medium
Q: NonTenant check	Low

Re: Top 3 Reason Types

sunny_talwar — Wed, 12 Apr 2017 11:33:44 GMT

Like this

Re: Top 3 Reason Types

manojkulkarni — Wed, 12 Apr 2017 12:07:38 GMT

Thanks for your immediate response. This is working.

What we are expecting here is , Occurrence will be my Label Heading & Highest count of cases of a reason should be displayed based on data in Text Object

Re: Top 3 Reason Types

tresB — Wed, 12 Apr 2017 12:30:21 GMT

Like this?

Re: Top 3 Reason Types

manojkulkarni — Wed, 12 Apr 2017 14:46:24 GMT

Thanks Tresesco for solution. How we should handle when we have same count for 2 different reason ?

example:

Table:

LOAD * INLINE [

CaseID, Reason

449790, Q: Identify Payee

453917, Q: Identify Payee

456423, Q: Identify Payee

456427, Q: Identify Payee

455388, Q: Identify Payee

455386, Q: Identify Payee

456900, Q: NonTenant check

453845, Q: Advise on Allocation of Receipt

456757, Q: Advise on Allocation of Receipt

456759, Q: Advise on Allocation of Receipt

456804, Q: Advise on Allocation of Receipt

456814, Q: Advise on Allocation of Receipt

456806, Q: Identify Payee

445595, Q: Advise on Allocation of Receipt

456783, Q: Advise on Allocation of Receipt

446283, Q: NonTenant check

];

Re: Top 3 Reason Types

sunny_talwar — Wed, 12 Apr 2017 14:47:43 GMT

What would be the expected output? See both?

Re: Top 3 Reason Types

sunny_talwar — Wed, 12 Apr 2017 14:58:50 GMT

Something like attached

Re: Top 3 Reason Types

sakthi266 — Wed, 12 Apr 2017 16:17:10 GMT

Hi Sunny Talwar,

Expected Result is Like this

High : Q: Advise on Allocation of Receipt

Medium : Q: Identify Payee

Low : Q: NonTenant check

Because , Q: Advise on Allocation of Receipt and Q: Identify Payee are 7 , By Alphabet It should show like this.

File Attached is showing given below

High : Q: Advise on Allocation of Receipt

Medium : Q: NonTenant check

Low : Null

Re: Top 3 Reason Types

sunny_talwar — Wed, 12 Apr 2017 16:19:29 GMT

Check attached