Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a List Box based on Numerical Fields

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:

                                  

SupplierPVO 3rdPVO SecPVO 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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

one solution could be with conditional expression

PFA

View solution in original post

2 Replies
maxgro
MVP
MVP

one solution could be with conditional expression

PFA

Not applicable
Author

That works great, Massimo!  Thanks for the help.