Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Showing All Rows Based On List Box Selection

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.

1 Solution

Accepted Solutions
swuehl
Not applicable

Showing All Rows Based On List Box Selection

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

2 Replies
tresesco
Not applicable

Showing All Rows Based On List Box Selection

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

Regards,  tresesco

swuehl
Not applicable

Showing All Rows Based On List Box Selection

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