Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

matheus_silva
Contributor

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
marcioarruda
Contributor III

Re: SALES ANALYSIS

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

9 Replies
marcioarruda
Contributor III

Re: SALES ANALYSIS

Look at this

vishsaggi
Esteemed Contributor III

Re: SALES ANALYSIS

Try this in your list box?

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

matheus_silva
Contributor

Re: SALES ANALYSIS

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??

marcioarruda
Contributor III

Re: SALES ANALYSIS

Try this:

matheus_silva
Contributor

Re: SALES ANALYSIS

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...=/

marcioarruda
Contributor III

Re: SALES ANALYSIS

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

matheus_silva
Contributor

Re: SALES ANALYSIS

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

marcioarruda
Contributor III

Re: SALES ANALYSIS

Did you run the last attachment I sent?

matheus_silva
Contributor

Re: SALES ANALYSIS

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

Community Browser