topic Re: Display top 25 partial sums in QlikView

Display top 25 partial sums

Fri, 21 Jun 2013 09:33:56 GMT

Is it possible to display only the top 25 partial sums?

Re: Display top 25 partial sums

Fri, 21 Jun 2013 10:03:10 GMT

YOU CAN DO THIS IN SCRIPT,

THIS IS THE ALTERNATIVE SOLUTION OF YOUR QUESTION.

HOPE THIS HELPS YOU.

TEMP:

LOAD * INLINE [

NAME, PRICE

A, 4

A, 2

A, 5

B, 7

B, 8

C, 9

C, 4

C, 12

D, 45

D, 6

];

DATA:

LOAD NAME ,SUM(PRICE) AS PATIALSUM Resident TEMP

Group BY NAME ;

LOAD

RowNo() AS KEY,

NAME AS NEWNAME,

PATIALSUM AS TOP2_PARTIAL_SUM

Resident DATA

Where RowNo()<2;

DROP Table TEMP;

SEE ATTACHEMENT.

Regards

Vishwaranjan

Re: Display top 25 partial sums

Fri, 21 Jun 2013 10:06:14 GMT

is there anyway to do it without touching my script?

Date: Fri, 21 Jun 2013 06:03:16 -0400

From: qcwebmaster@qlik.com

To: eugene-fcuk@live.com.sg

Subject: - Re: Display top 25 partial sums

QlikCommunity

Re: Display top 25 partial sums created by vishwaranjan in New to QlikView - View the full discussion

YOU CAN DO THIS IN SCRIPT,

THIS IS THE ALTERNATIVE SOLUTION OF YOUR QUESTION.

HOPE THIS HELPS YOU.

TEMP:

LOAD * INLINE [

NAME, PRICE

A, 4

A, 2

A, 5

B, 7

B, 8

C, 9

C, 4

C, 12

D, 45

D, 6

];

DATA:

LOAD NAME ,SUM(PRICE) AS PATIALSUM Resident TEMP

Group BY NAME ;

LOAD

RowNo() AS KEY,

NAME AS NEWNAME,

PATIALSUM AS TOP2_PARTIAL_SUM

Resident DATA

Where RowNo()<2;

DROP Table TEMP;

SEE ATTACHEMENT.

Regards

Vishwaranjan

Reply to this message by replying to this email -or- go to the message on QlikCommunity

Start a new discussion in New to QlikView by email or at QlikCommunity

Re: Display top 25 partial sums

Fri, 21 Jun 2013 10:06:37 GMT

Can i do it without touching my script?

Re: Display top 25 partial sums

er_mohit — Fri, 21 Jun 2013 10:10:00 GMT

Got o this link

http://community.qlik.com/thread/67816

Re: Display top 25 partial sums

Fri, 21 Jun 2013 10:22:34 GMT

TEMP:

LOAD * INLINE [

NAME, PRICE

A, 4

A, 2

A, 5

B, 7

B, 8

C, 9

C, 4

C, 12

D, 45

D, 6

];

in pivote--

dimension1= NAME

DIMENSION2= PRICE

EXPRESSION=
if(aggr(rank(sum(PRICE)),NAME)<=2,sum(PRICE))

IN PRESENTATION TAB SELECT FIELD PRICE THEN CHECK ON SHOW PARTIAL SUM

THEN YOU GET THE TOP 2 PARTIAL SUM.

SEE ATTACHEMENT