Create a List Box based on Numerical Fields

Tue, 10 Feb 2015 17:35:35 GMT

Hello All,

I am trying to create a list box based on input from 3 fields. The three fields contain numerical spend data. I would like to use the list box to the populate a chart based on the criteria selected.

The 3 fields would be structured as such:

Supplier	PVO 3rd	PVO Sec	PVO Div
1	$4
2	$5
3		$1
4			$5
5	$6
6		$3
7			$7
8	$1

The criteria in the list box should then be "PVO 3rd", "PVO Sec", and "PVO Div". Based on the criteria selected, the chart would show the total amount of spend. In the above example, if "PVO 3rd" were selected, the chart would show a total of $16. Currently, when I try to select PVO 3rd as a criteria, all of the fields numerical values appear as criteria.

Any suggestions on how to proceed?

Thanks,

Gary

Re: Create a List Box based on Numerical Fields

maxgro — Tue, 10 Feb 2015 17:57:08 GMT

one solution could be with conditional expression

PFA

Re: Create a List Box based on Numerical Fields

Tue, 10 Feb 2015 21:52:38 GMT

That works great, Massimo! Thanks for the help.

topic Create a List Box based on Numerical Fields in QlikView

Create a List Box based on Numerical Fields

Re: Create a List Box based on Numerical Fields

Re: Create a List Box based on Numerical Fields