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: 
Anonymous
Not applicable

SALES ANALYSIS

Hi folks  

  Now i have a complicated job, simplifying i have make a report to show how much of one product sales, when the product "x" was in offer, for example...Atached have a sample..

What i want is filter a product and qlikview show me how much coupon have that product and after show me all product of that coupon...

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

So it is certainly less expensive, since the second reading is made of what is already in memory.

View solution in original post

9 Replies
Anonymous
Not applicable
Author

Look at this

vishsaggi
Champion III
Champion III

Try this in your list box?

= IF(Coupon = GetFieldSelections(Coupon), Product)

Anonymous
Not applicable
Author

Thank you by return, but not works...

Actually, my purpose is filter a only product and knows which product sales more.

I put beer in offer and consequently i sell that another product??

Anonymous
Not applicable
Author

Try this:

Anonymous
Not applicable
Author

Almost there...

Look the new attachment , its what i need...but i have a problem, my .qvd is big, and reload twice is very expensive...computationally...but works...

Maybe using Resident works too...but i want somethig more fast you know...=/

Anonymous
Not applicable
Author

So it is certainly less expensive, since the second reading is made of what is already in memory.

Anonymous
Not applicable
Author

Yes, i think that is the only way...

Anonymous
Not applicable
Author

Did you run the last attachment I sent?

Anonymous
Not applicable
Author

Yes, its works...Thank man....