topic straight table in QlikView

straight table

Thu, 08 Dec 2011 04:13:16 GMT

Hi,

I have straight table like bellow

here i need to sum first four , i dont want last one how can we do ,can any one help me

Thanks,

Jyothi

Thu, 08 Dec 2011 06:14:47 GMT

Hi,

Try this in expression part of staight table:

=sum({ $< segments = E({ 1<segments={'D5'}> }) > } values )

but it will not show you the whole row of D5 segments.

Apurva

jagan — Thu, 08 Dec 2011 06:26:15 GMT

Hi Jyothi,

Put Segments in Dimension, and use expression

=If(RowNo() <=4, Values, Null())

and in presentation tab limit Number of rows 4.

This shows only 4 rows in the straight table.

Regards,

Jagan.

Thu, 08 Dec 2011 07:20:16 GMT

Hi I have Used the same example of Jagan but with little modifcation.

I have use the variable and input box.

Now you can dynamically change your range as per your requirement.

Regards,

Nitin Jain

Fri, 09 Dec 2011 11:09:37 GMT

Thanks you for you replay apurva

Thanks,

Jyothi

On Thu, Dec 8, 2011 at 11:45 AM, Apurva ... <

Fri, 09 Dec 2011 12:09:06 GMT

Thank u so-much Jagan

R u happy

On Thu, Dec 8, 2011 at 11:56 AM, jagan mohan <