topic Re: Show Certain Row in Straight Table in QlikView

Show Certain Row in Straight Table

Thu, 15 Aug 2013 01:14:00 GMT

Dear Team,

i have a following straight table, and i use rowno(total) to get the row number

Employee	rowno(TOTAL)
AAA	1
BBB	2
CCC	3
DDD	4
EEE	5

My question, how do i display certain row? For example, I want to display row 2 to 4. Means showing 3 rows only.

or show row 1 to 4 only

thank you

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 04:40:44 GMT

Hi,

Try like this

Script:

Test:

LOAD * INLINE [

Data

AAA

BBB

CCC

DDD

EEE ];

Use this as expression

=If(FieldIndex('Data', Data)>=2 AND FieldIndex('Data', Data)<= 4, FieldIndex('Data', Data))

Hope this helps you.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 05:32:11 GMT

The table i show actually is the straight table already.

I generate the rowno and assign in a expression

WHere should i put this expression??

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 06:53:37 GMT

Hi,

Check this file.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 07:03:01 GMT

Thanks mohan for the sample

May i know more about this expression

"=If(FieldIndex('Data', Data)>=2 AND FieldIndex('Data', Data)<= 4, FieldIndex('Data', Data))"

Understand the Data is the field name. But what about the 'Data' with Apostrophe?? what should i replace with?

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 07:08:34 GMT

Hi,

For the detailed help you can check the help file by pressing F1 key.

The syntax for FieldIndex is

FieldIndex('Dimension Name', value) - which will give you the index.

FieldIndex('Data', Data)

In the above I am specifying the column name in single quotes and specifying the value without quotes. Hope it helps you.

Please close the discussion if my post solves your requirement by clicking correct and useful answers to my posts.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 07:16:36 GMT

Jagan,

Perhaps u may take a look on my file. not every sure how to apply ur method.

as i dun have insert attachment. u may download the file from my google drive

i have the rowno expression, and how do i only show certain rowno. The row no is not the row in database. The row no is created during runtime

https://docs.google.com/file/d/0B6c7Q2c9qyF3cnE5YUR4MnBOMTg/edit?usp=sharing

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 07:20:01 GMT

Hi,

You just replace the RowNo() expression with this

=If(FieldIndex('Data', Data)>=2 AND FieldIndex('Data', Data)<= 4, FieldIndex('Data', Data))

Please find attached file above for reference.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 07:23:38 GMT

I did replace with the one in your attachment. But it shown '-' for all the row

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 07:26:07 GMT

Hi,

Can you attach the sample file to your post, I am unable to download from google drive.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 07:29:54 GMT

Attached is my file.

Just manage to find this attach option. Thanks

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 07:48:16 GMT

Hi,

Please find attached file, I did the following changes

- Modified all the expressions

- Selected the "Suppress When value is Null" for dimension in Dimension tab.

- Selected the "Suppress Missing" option in Presentation tab.

Hope this helps you.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 07:56:36 GMT

Thanks Jagan,

You refer to the below table which is original one.

How come your 234 row is totally different from the original one?

Anyway, your changes is so almost there.

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 08:03:33 GMT

Hi,

FieldIndex() will return the value of the Index, in the expression we get those whose index are 2, 3 and 4. That is what the records are displayed in my attached file.

I am not sure what you are asking, is the entire row is different including dimension or expression values are different?

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 08:07:03 GMT

As you can see the original table 2,3,4 is following name

ABDUL MALEK S

ABELARDO C MENESES

AIZUDDIN BIN MD S

But the field index giving different kind of result. What i want is if i specify row 2-4. Then it will return the 2-4 name

thanks

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 08:56:00 GMT

Hi,

Sort the names in the script, then you will get the values correctly.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Thu, 15 Aug 2013 09:20:04 GMT

Jagan,

Happened to see your this thread in the community. I think maybe i should give up the display certain row and apply the paging for my straight table.

http://community.qlik.com/docs/DOC-3890

how could i apply to my work?

Re: Show Certain Row in Straight Table

jagan — Thu, 15 Aug 2013 10:41:28 GMT

Hi,

Can you attach the Visual-all.txt file, need to change some script, I think you need the paging implementation.

Regards,

Jagan.

Re: Show Certain Row in Straight Table

Fri, 16 Aug 2013 00:31:35 GMT

Yup. I think paging method as well.

Hope you could help.

Thanks Jagan

Re: Show Certain Row in Straight Table

jagan — Fri, 16 Aug 2013 02:41:19 GMT

Hi,

Try this script it sorts the names

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Temp:
LOAD b_LoginID,
     b_FullName,
     b_UserDepartment,
     b_Supervisor,
     b_UserDeptSection,
     b_OrderNumber,
     b_OrderLine,
     b_OrderLinePart,
     b_CustomerName,
     b_BookingTypeDesc,
     b_ProductivityTypeDesc,
     b_BookedTime,
     b_IndirectHours,
     b_DirectHours,
     b_LaborCode,
     b_LaborCodeDesc,
     b_Shift,
     b_JobNo,
     b_StartDate,
     b_EndDate,
     b_StartTime,
     b_EndTime,
     b_OTIndHours,
     b_OTDirHours,
     b_Code,
     b_Absence,
     b_AbsenceHrs,
     b_LastRun,
     b_SinceWhen,
     if(b_SinceWhen='', null(), 1) AS [b_InProcessFlag],
     b_LunchTimeDirect,
     b_LunchTimeIndirect
FROM
DATA\visual-all.txt
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Data:
NoConcatenate LOAD
*
RESIDENT Temp
ORDER BY b_CustomerName;

DROP TABLE Temp;

Hope it helps you.

Regards,

Jagan.