topic Re: Showing a variable in text object in QlikView

Showing a variable in text object

Mon, 27 Aug 2012 07:09:47 GMT

[Inp july-Semp]:

LOAD 1 as Count,

     Locations,
     [Q2.Physician name upon their specialty]as [Physician name upon their specialty],
     [Physician Name];

FROM

[..\Data\EXCELs\Bilal-Mafraq inpatient (july - august - Sept).xlsx]
(ooxml, embedded labels, table is Sheet1);

let InpatientTotal = NoOfRows([Inp july-Semp]);

Now i want to show this in a text box, how can i do that?? do i have to create a variable in Settings => variable overview ??

Re: Showing a variable in text object

roger_stone — Mon, 27 Aug 2012 08:46:51 GMT

You'll need to change your statement to

let InpatientTotal = NoOfRows('[Inp july-Semp]');

but then when you create your text object, all you need in the Text box of the General tab is =$(InpatientTotal)

Cheers

Roger

Re: Showing a variable in text object

jagan — Mon, 27 Aug 2012 08:53:56 GMT

Hi,

Try this

[Inp july-Semp]:

LOAD 1 as Count,

     Locations,
     [Q2.Physician name upon their specialty]as [Physician name upon their specialty],
     [Physician Name];

FROM

[..\Data\EXCELs\Bilal-Mafraq inpatient (july - august - Sept).xlsx]
(ooxml, embedded labels, table is Sheet1)

LET vRows = NoOfRows('Inp july-Semp');

Now, you create a text object and give the following as expression

=vRows

Hope this helps you.

Regards,

Jagan.

Re: Showing a variable in text object

Mon, 27 Aug 2012 09:01:00 GMT

I tried Roger way and it showed me in the text box a '-' sign.

I tried Jagan way and it show me empty in textbox

Re: Showing a variable in text object

jagan — Mon, 27 Aug 2012 09:06:15 GMT

Hi,

Please check attached file for solution.

Regads,

Jagan.