Listbox with one option >1.000.000

[#1]

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

[alexandros17]

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]

in your script you cn create a value for this like

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

[#4 · Accepted solution]

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