topic Showing All Rows Based On List Box Selection in QlikView

Showing All Rows Based On List Box Selection

Thu, 09 Feb 2012 10:05:42 GMT

Hi All

Right what am doing is trying to analysis sales from my companies website and we are running different marketing campaigns for different product groups.

What am wanting to do is show all the rows of an invoice where the customer has purchased some thing from the selected product group.

For example if i select boardies from my list box i want to see all invoices and row where boardies has been one of the item purchased.

Is there a way of doing this any advise would be great.

Showing All Rows Based On List Box Selection

tresB — Thu, 09 Feb 2012 10:18:35 GMT

you are trying how qlikview works by default. if your data model is correct, you get it automatically in qv.

Regards, tresesco

Showing All Rows Based On List Box Selection

swuehl — Thu, 09 Feb 2012 10:19:10 GMT

Should be possible by using set analysis to create a selection of the possible invoices (using the p() function), and clearing the seleted items in the set.

Maybe something like this (assume you've selected in field item):

Create a straight table with customer, invoice, row and as expression

=only({<invoice=p(), item= >} item)

Hope this helps,

Stefan