Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
you are trying how qlikview works by default. if your data model is correct, you get it automatically in qv.
Regards, tresesco
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