Discussion Board for collaboration related to Creating Analytics for QlikView.
I need your help.
I received a new requirement, i have a one column in a excel list with the tile amount.
How can I show a Listbox in the qlikview document with the following content:
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.
Go to Solution.
if(Amount>1000000, '>1.000.00') as newfield
In the listbox use the expression (at the bottom of fields's list)
hope it helps
in your script you cn create a value for this like
if(amount>1.000.000,'>1.000.000') as Listbox