# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Specialist III

## dispaly in listbox

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

8 Replies
Highlighted

Hi,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Specialist III

thanks but for  input box how can i do?

Highlighted
Specialist III

Highlighted
Partner

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

Highlighted
Specialist III

thanks vishal.. but user want input box only.

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

Highlighted
Master

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.

Highlighted
Specialist III

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

Highlighted
Specialist II

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.