topic Help2 in QlikView

Help2

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

I have a lot of data and I would like an Excel file with data that is in cell 24 in the text box to show

and I attached a file

I want show value on row 24 and column d

please guide me

tamilarasu — Tue, 23 Aug 2016 04:28:45 GMT

Try this script.

Data:
LOAD D
FROM
s1.xlsx
(ooxml, No labels, table is Sheet2)
Where RecNo() = 24;

Let vValue = Peek('D');

DROP Table Data;

Create a textbox in front end and type the variable name like =vValue .

arulsettu — Tue, 23 Aug 2016 04:29:38 GMT

you want to load only 25 rows from the excel?

marjan_it — Tue, 23 Aug 2016 04:39:06 GMT

you can use it in the text object ,

=sum(if(نام='a23',[شماره پرسنلي]))