topic Bar Chart with Price range listbox in QlikView

Bar Chart with Price range listbox

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

i have created a bar chart with price. i want to create a listbox price range as a filter. Can anyone out there help help??

I need to have a price range

<1000

1001 - 2000

2001-3000

3001-5000

>5000

how can i do that? should i do it in back end script?

Rgds

Jim

antoniotiman — Wed, 27 Jul 2016 07:47:41 GMT

In Listbox Expression

Class(Price,1000)

jim_chan — Wed, 27 Jul 2016 08:54:48 GMT

what if the price is an expression - for example: sum(price) * 100/0.5 ?

can i still use it with Class() ?

RGds

Jim

antoniotiman — Wed, 27 Jul 2016 09:01:13 GMT

Try

Class(Aggr(Sum(Price)*100/0.5,Price),1000,'Price')

Wed, 27 Jul 2016 09:02:43 GMT

Try this : class(((price, 1000)*100/0.5))

tamilarasu — Wed, 27 Jul 2016 09:35:46 GMT

Hi Jim,

I have already replied in the below thread. Please avoid posting the same question multiple times.

jim_chan — Wed, 27 Jul 2016 09:37:29 GMT

i totally understand that. but i posted wrongly.