Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Mulitplicating rows and data filtering

Hello,

I've got problem with preparing report using QlikView.

I've got data in mysql database:

Customer:

ID, Name, Classification

1, Name 1, A

2, Name 2, B

3, Name 3, C

etc.

Order:

ID, ID_customer, Date, Product

1, 1, 2014-07-01, Product 1

2, 1, 2014-07-02, Product 2

3, 1, 2014-07-04, Product 3

4, 2, 2014-07-01, Product 1

5, 3, 2014-07-01, Product 3

What i need to do is straght table with columns:

customer name, customer classification

with filter on product and orderd date (range of dates).

i've tried triggers, expression etc and i've got problem to allow user to select product and to select range of dates for order date to present only customers with specified product that they but in set range of dates.

when I add order date as dimension to table it multiplies customer record to n where n is number of orders connected to customer, and also i don't know how to get this filter to refresh table base on selected dates range

i would use any help with that

regards

Tags (2)
3 Replies
Not applicable

Re: Mulitplicating rows and data filtering

Hello, I believe you had a problem with your Data model. Please find the attached file as reference.

!

Not applicable

Re: Mulitplicating rows and data filtering

thanks, but still i've customer multiplicated in two rows in your file. What I need is one row per customer and filter based on all his orders and products

Not applicable

Re: Mulitplicating rows and data filtering

Just create a Table Box with required  fields. CustomerName & CustomerClassfication. Then apply your filter on Product & Date and then Table box will show the respective data on the table box.

Please post sample qvw.

Community Browser