Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III
Contributor III

List Box

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

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

Please help me

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe one example could be:

QlikCommunity_Thread_285241_Pic1.JPG

QlikCommunity_Thread_285241_Pic2.JPG

QlikCommunity_Thread_285241_Pic3.JPG

hope this helps

regards

Marco

View solution in original post

10 Replies
YoussefBelloum
Champion
Champion

Hi,

you just need to do this on a list box:

=if(TYPE='ACTUAL', CLIENT)


attached below


its_anandrjs

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

Sum(Amount)

<0

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

asknyldz
Contributor III
Contributor III
Author

Dear Youssef,

Actually i don't need List Box for Client.

I need to below list box.

Sum(Amount)

<0

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

asknyldz
Contributor III
Contributor III
Author

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 LOJISTIKACTUAL6
AYAYDIN GIYIMACTUAL6
SUNEL TICARETACTUAL6
KASTAS KAUCUKACTUAL16
ANIL BETONACTUAL23
PORLANDACTUAL27
GL EVENTSACTUAL31
TUBORGACTUAL38
GALERI ISTANBUL MOBILYA DEKORASYONACTUAL45
its_anandrjs

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

YoussefBelloum
Champion
Champion

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

its_anandrjs

Try to add this calculated dimension

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

ben_pugh
Creator
Creator

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.

MarcoWedel

Hi,

maybe one example could be:

QlikCommunity_Thread_285241_Pic1.JPG

QlikCommunity_Thread_285241_Pic2.JPG

QlikCommunity_Thread_285241_Pic3.JPG

hope this helps

regards

Marco