Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Listbox with one option >1.000.000

Hello together,

I need your help.

I received a new requirement, i have a one column in a excel list with the tile amount.

amount
1.000
5.320.000
500

7.520.410

222.222

How can I show a Listbox in the qlikview document with the following content:

Listbox
>1.000.000

The Solution of the Qlikview should be, that all Amounts over 1.000.000 will be showable.

Do you have any solution, how I can fix the requirement.

Thank you.

Nikolaus80

1 Solution

Accepted Solutions
Not applicable

Re: Listbox with one option >1.000.000

if(Amount>1000000, '>1.000.00') as newfield

3 Replies

Re: Listbox with one option >1.000.000

In the listbox use the expression (at the bottom of fields's list)

and write

if(amount<=1000000,amount,'>1000000')

hope it helps

er_mohit
Honored Contributor II

Re: Listbox with one option >1.000.000

in your script you cn create a value for this like

if(amount>1.000.000,'>1.000.000') as Listbox

Not applicable

Re: Listbox with one option >1.000.000

if(Amount>1000000, '>1.000.00') as newfield

Community Browser