topic Re: Amount Brackets in Qlik Learning Discussions

Amount Brackets

mario-sarkis — Mon, 27 Oct 2014 15:27:34 GMT

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

MK_QSL — Mon, 27 Oct 2014 15:30:12 GMT

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

mario-sarkis — Mon, 27 Oct 2014 15:36:57 GMT

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 — Mon, 27 Oct 2014 15:48:41 GMT

I want This OUTPUT to show

% : means a cumulatative pourcentage

MK_QSL — Mon, 27 Oct 2014 16:40:09 GMT

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

SUM([No Clts])

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

Don't forget to change the 2nd expression to % Format using Number tab 🙂