topic Re: List Box in QlikView

List Box

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

Hi There,

I want to add a list box in my dashboard as below for only "ACTUAL" values.

You can find attached data and dashboard files

Sum(Amount)

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

Please help me

Re: List Box

YoussefBelloum — Fri, 15 Dec 2017 13:27:23 GMT

Hi,

you just need to do this on a list box:

=if(TYPE='ACTUAL', CLIENT)

attached below

Re: List Box

its_anandrjs — Fri, 15 Dec 2017 13:36:16 GMT

Can you please clear your requirement, what is mean by below data.

Sum(Amount)

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

Re: List Box

asknyldz — Fri, 15 Dec 2017 13:37:01 GMT

Dear Youssef,

Actually i don't need List Box for Client.

I need to below list box.

Sum(Amount)

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

Re: List Box

asknyldz — Fri, 15 Dec 2017 13:39:49 GMT

Dear Anand,

This is Total Amount.

I want to, when i click to 0-50

Straight table must show only Actual sum amount 0 to 50 values. i.e.

FILLO LOJISTIK	ACTUAL	6
AYAYDIN GIYIM	ACTUAL	6
SUNEL TICARET	ACTUAL	6
KASTAS KAUCUK	ACTUAL	16
ANIL BETON	ACTUAL	23
PORLAND	ACTUAL	27
GL EVENTS	ACTUAL	31
TUBORG	ACTUAL	38
GALERI ISTANBUL MOBILYA DEKORASYON	ACTUAL	45

Re: List Box

its_anandrjs — Fri, 15 Dec 2017 13:43:35 GMT

You have to use Class function here to create the buckets for this.

Re: List Box

YoussefBelloum — Fri, 15 Dec 2017 13:58:01 GMT

here is one method to do it, I'm sure there a lot of other approach better than this, but it works.

I just did the examples cases: <0 and >0

just finish the rest

find attached

Re: List Box

its_anandrjs — Fri, 15 Dec 2017 13:58:18 GMT

Try to add this calculated dimension

=Dual(Replace(class( AMOUNT,50 ),'<= x <','to'), NUM(class( AMOUNT,50)) )

Re: List Box

Ben_P — Fri, 15 Dec 2017 15:37:07 GMT

Using the Class function is the way to do this, as others have said.

An alternative if you don't like Class would be to use If or Case statements in your script to split the amounts into buckets, which you can then assign to a new field...

if(amount<50,bucket1,

if(amount<100,bucket2, etc.

Not as clean as using Class, but would do the job.

Re: List Box

MarcoWedel — Sun, 17 Dec 2017 23:40:20 GMT

Hi,

maybe one example could be:

hope this helps

regards

Marco

Re: List Box

asknyldz — Mon, 18 Dec 2017 04:58:57 GMT

Thanks everyone.