Display top 25 partial sums

[#1]

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

[#2]

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

[#3]

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

© 1993-2011 QlikTech International AB Copyright & Trademarks | Privacy | Terms of Use | Software EULA

[#4]

Can i do it without touching my script?

[er_mohit · Accepted solution]

Got o this link

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

[#6]

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