Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
soniasweety
Master
Master
Author

thanks but for  input box how can i do?

soniasweety
Master
Master
Author

Hi  Bala Bhaskar   any idea?

vishalarote
Partner - Creator II
Partner - Creator II

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
Master
Master
Author

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
Master
Master
Author

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
Specialist II
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.