First row in a straight table

sibin_jacob — Mon, 18 Feb 2013 07:37:32 GMT

Hai Team,

I have a straight table with dimension Physician_Name and expression Product_volume.

In this straight table I am showing all the physicians based on geography selection. I want to show the first physician name in a text box that means first row Physician name from the straight table. User can sort table based on Product volume so the order of table will change. everytime I need the first record from that table.

Is there any way to pick first row value from a straight table?

Thanks,

Sibin Jacob.C

Re: First row in a straight table

alexandros17 — Mon, 18 Feb 2013 08:09:28 GMT

Every object like chart and tables show values depending on dimensions and expression so, if you want to show a value outside the object you should have to replicate an expression with the same dimension. This is not possible in a text box, otherwise you could use a trick that is design a new table where the dimension limit show only a row and so displaing the first row as you need

Hope it helps

topic Re: First row in a straight table in QlikView

First row in a straight table

Re: First row in a straight table