topic Re: Back end Variable in QlikView

Back end Variable

abhaysingh — Wed, 03 Dec 2014 06:23:17 GMT

i want to do some calculation at backend for this i need to use one variable.

sum(sales),

i m trying to make it by using let variable. but it is not showing me

let Variable= sum(sales);

i am using it like above..

can any one tell me how it will happen

anbu1984 — Wed, 03 Dec 2014 06:25:41 GMT

Table:

Load sum(sales) as total_sales Inline [

Country,sales

IND,100

CHI,100

US,100 ];

Let variable = Peek('total_sales',0,'Table');

amit_saini — Wed, 03 Dec 2014 06:32:03 GMT

Try this:

LET vSales = '=sum(Sales)' ;

Thanks,

its_anandrjs — Wed, 03 Dec 2014 06:39:14 GMT

Hi,

Write a variable like

SET vSumVar = 'Sum(Sales)';

and use this variable in any chart like $(vSumVar) for get sum value

But if want to do it with the load script

Table:

Load Regions,sales

Inline [

Regions,sales

R1,300

R2,600

R3,800 ];

SumTab:

LOAD sum(sales) as SalVal Resident Table;

Let vSumVal = Peek('SalVal',0,'SumTab');

And plot this variable in any text object or chart $(vSumVal)

Regards

Anand