Discussion Board for collaboration related to Qlik Education.
please can anyone tell me how to write this following bracket by this order into a script
provide some more information... If you have created these in script,,, you can use dual function to generate sort order.
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 ?
I want This OUTPUT to show
% : means a cumulatative pourcentage
Load *, RowNo() as SortingOrder Inline
Cash In USD Bracket, No Clts
"750K - 1M", 126
"500K - 750K", 273
"250K - 500K", 723
Create a Pivot or Straight Table
[Cash In USD Bracket]
RangeSum(Above(Sum([No Clts]),0,RowNo()))/SUM(TOTAL [No Clts])
Don't forget to change the 2nd expression to % Format using Number tab :-)