topic How to retreive data from table/qvd and do calculation in expression itself? in QlikView

How to retreive data from table/qvd and do calculation in expression itself?

Wed, 02 May 2012 11:30:40 GMT

I have 2 tables in these way;

table 1: revenue

Date, Country, Revenue, Currency

24-4-2011, India, 1000, INR

table 2: USDconversion rate

Currency, USDrate

INR, 53.21

Now i want to write the expression for table which add Revenue_in_USD as row in same table. Expression should take USDRate from USDconversion table and revenue from revenue table and then convert into USD.

How to retreive data from table/qvd and do calculation in expression itself?

Wed, 02 May 2012 11:33:34 GMT

hi,

Instead of table take chart control. Add calculated dimension. Keep Chart Type as Table. This will serve your req..

Swapnil

How to retreive data from table/qvd and do calculation in expression itself?

Wed, 02 May 2012 11:49:40 GMT

I dont need any calculated dimension . Output table should be:

Date, Country, revenue, revenue_in_USD

24-04-2011 ,India, 1000, 18.79

How to retreive data from table/qvd and do calculation in expression itself?

jagan — Wed, 02 May 2012 12:01:07 GMT

Hi,

Calculate revenue_in_USD in script, then it would be easier to use as dimension. Try below script

TempTable:

LOAD

FROM Revenue;

LEFT JOIN (TempTable)

LOAD

FROM USDconversion;

Revenue:

LOAD

Date,

Country,

Revenue,

Currency,

USDrate,

Revenue/USDrate

RESIDENT TempTable;

DROP TABLE TempTable;

Hope this helps you.

Regards,

jagan.