dispaly in listbox

[soniasweety]

Hi all,

i want to show the ranges as amazon list way?   how can i do this?

req1 :  how many values present in that perticular ranges?

like  0-100 (50)

101-200(70)  like that

req2:    how can i give the two input boxes  then user can enter their ranges and see their data?   how can use single column for two input boxes?

Note: i have a column with  Ranges  like below

if(TotalAmount >10000000,' 10M+',

if(TotalAmount >1000000 and TotalAmount <=10000000 ,' 1M to 10 M',

if(TotalAmount >100000 and TotalAmount <=1000000 ,' 100K - 1M',

'$0 to 100K'

))) As Range_Filer

[PrashantSangle]

Hi,

1: take Range_Filer as list box and then go to list box > property > General > tick Show Frequency

Regards,

[soniasweety]

thanks but for  input box how can i do?

[soniasweety]

Hi  Bala Bhaskar   any idea?

[vishalarote]

Hi Sony,

First use INPUTFIELD function in backend like

INPUTFIELD TotalAmount

Create alternate states for same column

Create Pivot table and add Dimension as No(Your Dimension) and measure is ,

Measure 1: InputSum({a}TotalAmount)

Measure 2: InputSum({b}TotalAmount)

Measure 3: if(TotalAmount >10000000,' 10M+',

if(TotalAmount >1000000 and TotalAmount <=10000000 ,' 1M to 10 M',

if(TotalAmount >100000 and TotalAmount <=1000000 ,' 100K - 1M',

'$0 to 100K'

)))

above function you manually enter the value for TotalAmount.

Note: Here a and b is my alternate states name

Please Find Below app.

[soniasweety]

thanks vishal.. but user want input box only.  

how can i ahcieve this?   input box and slider object ? 

[balabhaskarqlik]

May be like this:

Create variables in UI like:

Let vMinAmount = Min(TotalAmount);

Let vMaxAmount = Max(TotalAmount);

Let vTotalAmount = Concat(ValueLoop($(vMinAmount),$(vMaxAmount)),',')

List values by,

In Input box select vTotalAmount.

Same expression in two inputboxes.

[soniasweety]

if use same  when user enter range  same values dispalying in input box.

here user should enter   two range values in two inputbox  the result should display in stright table

[neelamsaroha157]

Create 2 variables for vMinPrice and vMaxPrice and use the inputbox so that the users can enter their custom range.

In the expression either you can use a single expression with the if condition or you can use two separate expressions with the condition show -

Expression 1 - whatever you are using currently like may be count(Items)

Conditional show will be when value of vMinPrice and vMaxPrice  is null.

Expression 2 - Count({<Price={">=$(vMinPrice )<=$(vMaxPrice )"}>}Items)

Conditional show will be when value of vMinPrice and vMaxPrice  is not null.

Fele free to share a sample for more exploration.