topic Re: dispaly range as amazon in QlikView

dispaly in listbox

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: dispaly range as amazon

PrashantSangle — Thu, 16 Aug 2018 10:44:26 GMT

Hi,

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

Regards,

Re: dispaly range as amazon

soniasweety — Thu, 16 Aug 2018 11:58:46 GMT

thanks but for input box how can i do?

Re: dispaly range as amazon

soniasweety — Thu, 16 Aug 2018 12:12:51 GMT

Hi Bala Bhaskar any idea?

Re: dispaly range as amazon

vishalarote — Thu, 16 Aug 2018 12:19:39 GMT

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.

Re: dispaly range as amazon

soniasweety — Thu, 16 Aug 2018 12:23:10 GMT

thanks vishal.. but user want input box only.

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

Re: dispaly range as amazon

BalaBhaskar_Qlik — Thu, 16 Aug 2018 12:37:54 GMT

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.

Re: dispaly range as amazon

soniasweety — Thu, 16 Aug 2018 12:46:33 GMT

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

Re: dispaly range as amazon

neelamsaroha157 — Thu, 16 Aug 2018 13:18:32 GMT

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.