topic how to restrict top 10 fields data in straight table ? in QlikView

how to restrict top 10 fields data in straight table ?

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a straight table I need to get top 10 TGB Data's values based on Expression result

ThExpression used is:

=if(num(If(Rolling_7_days.AMPMTemp='AM',

Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL<[Rolling_7_days.TGB Name], [Rolling_7_days.File Date]> Rolling_7_days.Counts) /

Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts)-1,

Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL<[Rolling_7_days.TGB Name],[Rolling_7_days.File Date1]> Rolling_7_days.Counts)/

Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts) -1))>0,

num(If(Rolling_7_days.AMPMTemp='AM',

Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL<[Rolling_7_days.TGB Name], [Rolling_7_days.File Date]> Rolling_7_days.Counts) /

Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts)-1,

Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL<[Rolling_7_days.TGB Name],[Rolling_7_days.File Date1]> Rolling_7_days.Counts)/

Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts) -1)))

a dimension used is:

Thanks,

Muthu

Re: how to restrict top 10 fields data in straight table ?

sunny_talwar — Tue, 25 Apr 2017 11:22:44 GMT

May be using Dimension's limit tab to limit top 10 values?

QlikView 11 Dimension Limit Functionality

Re: how to restrict top 10 fields data in straight table ?

shiveshsingh — Tue, 25 Apr 2017 14:59:14 GMT

You can go to Chart properties, then click on Dimension Limits,

From there you can restrict the values to be displayed.

Re: how to restrict top 10 fields data in straight table ?

Tue, 25 Apr 2017 23:12:26 GMT

Thanks for your update stalwar1‌ and SHIVESH

But It's not working. I think it's because of my expression

can you give me a suitable Expression for it

Thanks,

Muthu

Re: how to restrict top 10 fields data in straight table ?

Siva_Sankar — Wed, 26 Apr 2017 02:27:06 GMT

Hi Muthu kumar,

What is the expression doing? ?You could handle complex expression in script side if possible?

Can you share sample data?

Siva

Re: how to restrict top 10 fields data in straight table ?

Anil_Babu_Samineni — Wed, 26 Apr 2017 02:29:38 GMT

If possible, please share sample

Re: how to restrict top 10 fields data in straight table ?

Wed, 26 Apr 2017 05:18:10 GMT

thanks for your response @Anil Babu Samineni and shankarece‌

Please find the sample data and sample Code for your reference.

kindly suggest me the expression so that it will be help full for me

Set Analysis Expression If possible

Thanks,

Muthu

Re: how to restrict top 10 fields data in straight table ?

Wed, 26 Apr 2017 05:19:08 GMT

I have attached the sample data for only one Day. but in Actual The sample Data has been Placed Based on AM and PM on a daily basis From that they are fetching the Data

Re: how to restrict top 10 fields data in straight table ?

Thu, 27 Apr 2017 06:26:03 GMT

Anyone Please reply and give me a solution

.can we able to add any calculated dimension to restrict top 10