Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor 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

Tags (1)
8 Replies

Re: dispaly range as amazon

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.
soniasweety
Valued Contributor III

Re: dispaly range as amazon

thanks but for  input box how can i do?

soniasweety
Valued Contributor III

Re: dispaly range as amazon

Hi  Bala Bhaskar   any idea?

Partner
Partner

Re: dispaly range as amazon

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

Capture2.PNG

Please Find Below app.

soniasweety
Valued Contributor III

Re: dispaly range as amazon

thanks vishal.. but user want input box only.  

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

balabhaskarqlik
Honored Contributor

Re: dispaly range as amazon

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
Valued Contributor III

Re: dispaly range as amazon

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
Valued Contributor II

Re: dispaly range as amazon

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.