Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Requirement on table box

Hi

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Requirement on table box

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?

15 Replies

Re: Requirement on table box

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?

MVP
MVP

Re: Requirement on table box

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

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

Capture.PNG

MVP
MVP

Re: Requirement on table box

Might be a good idea anyway..

Not applicable

Re: Requirement on table box

please give expression for Straight table

Re: Requirement on table box

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

Not applicable

Re: Requirement on table box

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

Not applicable

Re: Requirement on table box

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

MVP
MVP

Re: Requirement on table box

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?