Solved: Re: Filter by TopN record and calculate the Avg - Qlik Community

Report Inappropriate Content · ‎2011-09-29

Hi All,

I would like to calculate the win ratio base on the lastest TopN records and finally display the ratio in a Gauge Chart.

It like SQl

select Top 10 AVG(win_Ratio) from Customer where Customer = 'Customer 1' order by Date

Attached the example qvw

kaushiknsolanki · ‎2011-09-30

Hi,

Have a look at the example. Hope this will solve your problem.

Regards,

Kaushik Solanki

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

kaushiknsolanki · ‎2011-09-30

Hi,

Have a look at the example. Hope this will solve your problem.

Regards,

Kaushik Solanki

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