Re: Number of Items that make 99% of Amount - Qlik Community

retrocolor · ‎2013-04-07

Hi All,

I need to make a pivot table where I have the count of Top Items (by Sales Amount) that make 99% of total Amount?

Any ideas?

Thank you in advance!

Radi

kaushiknsolanki · ‎2013-04-08

Hi,

Find the attached QVW file.

Hope this is what you want.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

sushil353 · ‎2013-04-08

hi,

Please post the sample app.

HTH

Sushil

jagan · ‎2013-04-08

Hi,

You can try using the Pareto trigger option. Refer following URL

Hope this helps you.

Regards,

jagan.