topic giving value to max 5 value in QlikView

giving value to max 5 value

Wed, 12 Oct 2011 14:16:28 GMT

I am tring to give different values for max 5 row in straight table.

for example 1.max value=5,

------ 2.mav value=4,

------ 3.mav value=3,

------ 4.mav value=2,

------ 5.mav value=1

Re: giving value to max 5 value

its_anandrjs — Wed, 12 Oct 2011 14:20:12 GMT

Hi,

Sort the expression in descending order sum(Amount) and set a variable and use it to display top max values

Like vMax = 0 and use this variable in input box and set a variable in chart properties Max Number -> check mark it -> and paste a variable there =vMax

See the atttached sample file and solution sheet.

Rgds

Anand

Re: giving value to max 5 value

SunilChauhan — Wed, 12 Oct 2011 14:23:00 GMT

see the attached file

hope this you required

giving value to max 5 value

Wed, 12 Oct 2011 14:27:18 GMT

I am tring to find max Amounts and give them these values

giving value to max 5 value

its_anandrjs — Wed, 12 Oct 2011 14:34:31 GMT

Hi,

You see my application

Rgds

Anand

giving value to max 5 value

Wed, 12 Oct 2011 14:40:09 GMT

Name	CatID	sum(Amount)	value
		4748,59
Bill	3	1000	5
Chris	19	972,5	4
Jack	1	600	3
Chris	20	563,55	2
Chris	18	555	1
Bob	12	444
Bob	8	300
Jack	6	66
Bob	10	55
Bob	7	44
John	5	44
Bob	2	40
John	13	23
Jack	15	10
Bob	11	8
Chris	17	5,54
Bob	9	5
Jack	16	5
John	4	4
John	14	4

this is what I am tring to do

Re: giving value to max 5 value

its_anandrjs — Wed, 12 Oct 2011 14:49:49 GMT

Hi,

I suggest if in place of this if you set a variable then use this varaible in the strainght chart to diaplay top 5, top 10, top 15 etc is a best parctice to show the data

See the attached Solution Sheet sample file.

Rgds

Anand

Re: giving value to max 5 value

vincent_ardiet — Wed, 12 Oct 2011 15:03:28 GMT

Hi,

Try this expression : =6-if(rank(Total Amount)<=5,rank(Total Amount))

Regards,

Vincent

Re: giving value to max 5 value

its_anandrjs — Wed, 12 Oct 2011 15:09:40 GMT

Hi,

Use this code

if(isnull(6-if(rank(Total Amount)<=5,rank(Total Amount))) , ' ',6-if(rank(Total Amount)<=5,rank(Total Amount)))

As a rank of the table in second expression.

See the attched.

Rgds

Anand

Re: giving value to max 5 value

Wed, 12 Oct 2011 16:25:40 GMT

this is absolutely what I need thank you very much:))

can I calculate total amount with a set analysis