topic Re: Sheet Object in QlikView

Sheet Object

Fri, 21 Nov 2014 06:53:51 GMT

How many charts are kept in one sheet?

Re: Sheet Object

abhaysingh — Fri, 21 Nov 2014 07:13:00 GMT

As many you want

Re: Sheet Object

Anonymous — Fri, 21 Nov 2014 07:14:57 GMT

Hey,

There is no such limit for a sheet.

You can keep any number of objects. If number of objects are increase you will get scroll bars to provide enough space to all the charts.

Hope this helps.

Chinna

Re: Sheet Object

MK_QSL — Fri, 21 Nov 2014 07:15:07 GMT

Depends on

1) windows size (screen size) you kept, if user don't want scroll bar

2) if user accept scroll bar, as many as you can... but would prefer vertical scroll bar most rather than horizontal one

(even though would not prefer to have scroll bar at all...)

3) you can use

fast type change,

hide and show objects based on selection,

customized tables and charts,

containers

to show more charts compare to the space available..

Hope this would help

Re: Sheet Object

Fri, 21 Nov 2014 07:15:21 GMT

What is the difference between pick and peek function?

Re: Sheet Object

MK_QSL — Fri, 21 Nov 2014 07:24:08 GMT

Peek() is used in the script, pick() - on the front end. From Help:

peek(fieldname [ , row [ , tablename ] ] )

Returns the contents of the fieldname in the record specified by row in the internal table tablename. Data are fetched from the associative QlikView database.

Fieldname must be given as a string (e.g. a quoted literal).

Row must be an integer. 0 denotes the first record, 1 the second and so on. Negative numbers indicate order from the end of the table. -1 denotes the last record read.

If no row is stated, -1 is assumed.

Tablename is a table label, see Table Labels, without the ending colon. If no tablename is stated, the current table is assumed. If used outside the load statement or referring to another table, the tablename must be included.

Examples:

peek( 'Sales' )
returns the value of Sales in the previous record read ( equivalent to previous(Sales) ).

peek( 'Sales', 2 )
returns the value of Sales from the third record read from the current internal table.

peek( 'Sales', -2 )
returns the value of Sales from the second last record read into the current internal table.

peek( 'Sales', 0, 'Tab1' )
returns the value of Sales from the first record read into the input table labeled Tab1.

Load A, B, numsum( B, peek( 'Bsum' ) ) as Bsum...;
creates an accumulation of B in Bsum.

pick(n, expr1[ , expr2,...exprN])

Returns the n:th expression in the list. n is an integer between 1 and N.

Example:

pick( N'A''B'4, , , )

returns 'B' if N = 2

returns 4 if N = 3

Re: Sheet Object

Fri, 21 Nov 2014 07:31:52 GMT

Thanks Manish:) I got what I expected....