Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Separate Product Columns

Hi,

I have a number of products, split across different columns which I need to work with. I have attached a sample file of the data that I am working with.

What I would like to do is create a List Box (or similar) with Products A, B, C, D as options.

So far all I have been able to do is get a List Box with a single product and the options within the box are the various prices.

On selection, the ideal behaviour would be to look for the presence of a value in the particular column (as this would indicate that there was a sale) and then all other values would be filtered accordingly. It should be possible to select multiple values.

I think this may involve some kind of 'CountIf' type expression.

I hope this makes sense. I have a feeling that this is easy-ish but after a number of trials I am no closer!

Many thanks in advance.

Al

0 Replies