topic freeze top row on a table in QlikView

freeze top row on a table

alec1982 — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

i have the following table and i want the top row always visible (freeze it)..

I used to do that using an aggregated dimension but that didnt work.. anyone has a solution

Dim1,Dim2,Dim3, Value1, Value2

AA,BB,CC,4,5

a,s,d,1,2

b,d,s,2,3

c,d,a,4,3

d,f,g,5,4

MK_QSL — Wed, 14 Mar 2018 21:39:01 GMT

TOP row means

AA, BB, CC, 4 , 5?

MK_QSL — Wed, 14 Mar 2018 21:41:33 GMT

You can use a straight table

dimensions

Dim1

Dim2

Dim3

Expressions

SUM({<Dim1 += {'AA'}>}Value1)

SUM({<Dim1 += {'AA'}>}Value2)

alec1982 — Wed, 14 Mar 2018 22:20:53 GMT

yes

alec1982 — Wed, 14 Mar 2018 22:24:18 GMT

I dont think that freezes the top row..

MK_QSL — Thu, 15 Mar 2018 09:29:52 GMT

It will not freeze up but you will get that line even after selecting anything from your list box..

There is nothing like freeze rows same as Excel here..