Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor

Amount Brackets

hi all,

please can anyone tell me how to write this following bracket by this order into a script

[>=1M]
[750K - 1M]
[500K - 750K]
[250K - 500K]
[<=250K]

Thank You

4 Replies
MVP
MVP

Re: Amount Brackets

provide some more information... If you have created these in script,,, you can use dual function to generate sort order.

mario-sarkis
Contributor

Re: Amount Brackets

i didnt Create it i just need to creat it in a script is it ana inline table or something if it is how should i write it ?

mario-sarkis
Contributor

Re: Amount Brackets

I want This OUTPUT to show

% : means a cumulatative pourcentage

Cash In USD BracketNo Clts% Cum.
[>=1M]3907%
[750K - 1M]12610%
[500K - 750K]27315%
[250K - 500K]72328%
[<=250K]3,795100%
TOTAL5,307
MVP
MVP

Re: Amount Brackets

Load *, RowNo() as SortingOrder Inline

[

  Cash In USD Bracket, No Clts

  ">=1M", 390

  "750K - 1M", 126

  "500K - 750K", 273

  "250K - 500K", 723

  "<=250K", 3795

];

Create a Pivot or Straight Table

Dimension

[Cash In USD Bracket]

Expression

1)

SUM([No Clts])

2)

RangeSum(Above(Sum([No Clts]),0,RowNo()))/SUM(TOTAL [No Clts])

Don't forget to change the 2nd expression to % Format using Number tab :-)

Community Browser