topic Re: Requirement on table box in QlikView

Requirement on table box

Wed, 25 Nov 2020 16:16:04 GMT

i have table box in that i have 5 fields

for example:

City population Growth P% Status

London, 22000 2% 1% Green

New York 12500 1% 0.5% yellow

Spain 52000 29% 5% Green

Delhi 1300 0% 2% Red

Hyd 15000 5% 1% green

i have to display only last 3 records how to do this .i am using table box here

Thanks

Re: Requirement on table box

sunny_talwar — Fri, 13 May 2016 21:02:51 GMT

Is there a reason you want to do this in table box? Straight table won't work? and why the last 3 records? What is so unique about them?

Re: Requirement on table box

swuehl — Fri, 13 May 2016 21:03:39 GMT

Select Spain, Delhi and Hyd

You can't use expressions or filters in the table box object, so maybe use a straight table chart if you need a filter within the object.

Re: Requirement on table box

sunny_talwar — Fri, 13 May 2016 21:06:28 GMT

I was thinking of flagging the last three rows with 1 and rest of the 2 as null and then on the properties tab going to select 'Omit Rows Where Field is Null' for the flag dimension. But I really don't know what the goal is

Re: Requirement on table box

swuehl — Fri, 13 May 2016 21:12:25 GMT

Might be a good idea anyway..

Re: Requirement on table box

Fri, 13 May 2016 21:28:49 GMT

please give expression for Straight table

Re: Requirement on table box

sunny_talwar — Fri, 13 May 2016 21:37:46 GMT

What is the logic? Unless we know why you want to show the last 3 it would be difficult to offer a solution

Re: Requirement on table box

Fri, 13 May 2016 21:41:18 GMT

i have 55 records in Field City but i have to show the records only 5 among that 55 in any table or straight table

Re: Requirement on table box

Fri, 13 May 2016 21:43:31 GMT

i have to show the data only few particular Cities(Only 5records)

Re: Requirement on table box

swuehl — Fri, 13 May 2016 22:07:19 GMT

Create a straight table chart with all your 5 fields as dimension and a single expression

=Only({<City = {Spain,Delhi,Hyd}>} City) // adapt the list of cities as needed

On presentation tab of chart properties, hide the expression column.

Is this what you want?

Re: Requirement on table box

engishfaque — Fri, 13 May 2016 23:15:11 GMT

Dear Abubakar,

Kindly use listed below data model for loading last 3 records. For more, Kindly find attached App.

[Temp Table]:

LOAD *, RecNo() as Temp_RecNo Inline [

City, population, Growth, P%, Status

London, 22000, 2%, 1%, Green

New York, 12500, 1%, 0.5%, yellow

Spain, 52000, 29%, 5%, Green

Delhi, 1300, 0%, 2%, Red

Hyd, 15000, 5%, 1%, green

];

First 3 //Load First 3 Records, you can increase the number of last record load by replace 3 with you required number of records

NoConcatenate

[Main Table]:

LOAD

Resident [Temp Table]

Order By Temp_RecNo desc;

DROP Field Temp_RecNo;

DROP Table [Temp Table];

Kind regards,

Ishfaque Ahmed

Re: Requirement on table box

MarcoWedel — Sat, 14 May 2016 00:10:06 GMT

Hi,

as the number seems more important than the actual values, maybe one solution might be:

table1:

LOAD * INLINE [

City, population, Growth, P%, Status

London, 22000, 2%, 1%, Green

New York, 12500, 1%, 0.5%, yellow

Spain, 52000, 29%, 5%, Green

Delhi, 1300, 0%, 2%, Red

Hyd, 15000, 5%, 1%, green

];

hope this helps

regards

Marco

Re: Requirement on table box

Tue, 17 May 2016 16:03:31 GMT

Correct Answer

Re: Requirement on table box

MarcoWedel — Tue, 17 May 2016 17:53:45 GMT

Please mark an answer correct to close your thread.

thanks

regards

Marco

Re: Requirement on table box

Anil_Babu_Samineni — Tue, 17 May 2016 18:02:11 GMT

Siddiq,

How Marco's file is correct.

If you are added one more row. Then you will not get that data(Row) right.

So, Please check that...!

If fine, Your issue which mention the Marco please Mark the Correct Answer...

Good Luck...

Re: Requirement on table box

Tue, 17 May 2016 21:38:37 GMT

i implemented below expression

=Only({<City = {Spain,Delhi,Hyd}>} City)