topic Re: Limiting data in straight table in QlikView

Limiting data in straight table

mail2bsk — Fri, 06 Nov 2015 18:40:40 GMT

Hi,

i want to limit data in straight table based on two different conditions.

output table should contain:-

Top 4 Risks from Type (Top N is calculated based on Risk Number and Date) and Issues that are High Priority.

Table structure is as below

Date	Type	Priority	Risk Number
4/3/2015	Risk	High	7
5/3/2015	Risk	Low	7
9/23/2014	Risk	Medium	7
4/30/2015	Risk	High	6
4/3/2015	Issue	High	1
3/30/2015	Issue	High	1
5/20/2015	Issue	Low	1
9/23/2014	Risk	High	5

Thanks,

SK.

Kushal_Chawda — Fri, 06 Nov 2015 18:50:11 GMT

What will be the output?

mail2bsk — Fri, 06 Nov 2015 19:13:03 GMT

Output would be:

Date	Type	Priority	Risk Number
4/3/2015	Risk	High	7
5/3/2015	Risk	Low	7
9/23/2014	Risk	Medium	7
4/30/2015	Risk	High	6
4/3/2015	Issue	High	1
3/30/2015	Issue	High	1

sinanozdemir — Fri, 06 Nov 2015 21:16:43 GMT

Hi,

I might be getting your requirements wrong, but these are not really top 4 types:

As you can see when I use Rank(), these records are top 6 records.

Is that what you are really looking for?

mail2bsk — Sun, 08 Nov 2015 18:07:31 GMT

My requirement is to show Top 3 records of Type is Risk based on Risk number and High Priority records where Type Issues.