topic Re: Need help in calculating Top n values in QlikView

Need help in calculating Top n values

Wed, 05 Sep 2012 12:20:07 GMT

Hello All,

here i need help again from you guys..

I have a hierarchy like this Type--->Program-->SubProgram now in the horizantal bar chart i need to show top 3 subprograms for each Program.

Please Please need your help in getting this done, as i have no idea on how to do that.

Thanks & Regards,

Venkat T

Re: Need help in calculating Top n values

Thu, 06 Sep 2012 08:23:29 GMT

Hello any help here plsss....

am really stuck..

Thanks & Regards,

Venkat T

Re: Need help in calculating Top n values

Jason_Michaelides — Thu, 06 Sep 2012 08:28:46 GMT

What version of QlikView are you using?

Re: Need help in calculating Top n values

daveamz — Thu, 06 Sep 2012 08:29:05 GMT

Hi,

What version of QV are you using?

In QV 11 you can do that from Chart Properties > Dimension Limits

Regards,

David

Re: Need help in calculating Top n values

Jason_Michaelides — Thu, 06 Sep 2012 08:29:58 GMT

Exact reason I was asking

Re: Need help in calculating Top n values

Thu, 06 Sep 2012 08:47:46 GMT

Hi Dave,

Thanks for you reply....am aware of this optin but here in this chart i wont be showing Program...i would be displaying only SubProgram which has to be shown top 3 for each Program

Thanks & Regards,

Venkat T

Re: Need help in calculating Top n values

Tue, 18 Sep 2012 10:12:00 GMT

Hello experts,

Any help on the above one please.

Thanks & Regards,

Venkat T

Re: Need help in calculating Top n values

jagan — Tue, 18 Sep 2012 11:46:08 GMT

Hi,

Can you attach some sample data?

Regards,

Jagan.

Re: Need help in calculating Top n values

Wed, 03 Oct 2012 07:54:44 GMT

Hello All,

Am still not found the solution for the above requirement not even from the experts.but i would still feel it can be done.

I need to find out the top 3 Subprograms under Each prorgram and show them only those 3(under each Program) in the horizantal bar chart.

Thanks & Regards,

Venkat T

Re: Need help in calculating Top n values

Tue, 16 Oct 2012 11:29:18 GMT

any help on the above please

Re: Need help in calculating Top n values

jagan — Tue, 16 Oct 2012 12:06:52 GMT

Hi Venkat,

Check attached file hope it helps you.

Regards,

Jagan.

Re: Need help in calculating Top n values

Wed, 17 Oct 2012 11:29:56 GMT

Hello Jagan,

Thanks for your work around.But here the trick is that i cant show Program Grp, i need to show only Top 3 SubProgrmas under each Program Grp..

Thanks & Regards,

Venkat T

Re: Need help in calculating Top n values

jagan — Wed, 17 Oct 2012 16:18:29 GMT

Hi Venkat,

I think it is not possible, you need Program Grp dimension otherwise you will get the top 3 SubProgrmes overall.

Regards,

Jagan.