***Calculations in straight or pivot table**Urgent!

[Anonymous]

Hi,

I have data from this spreadsheet which shows the number of tourists going to the countries listed on yearly basis.

total = num1 + num2 + num3 + num4 + num5 + num6

eg: Paris total 1619 = 53+18+556+63+929

1% = num1/total ;  2% = num2/total  and so on..

eg: 53/1619 = 3%

Can someone please help me to write this expressions in qlikview and show in a straight/pivot table.

Thanks!

[fred_s]

Hi Chinnukool,

This should get you started (see attachm)

Grtz Fred

[hic]

You should use one (or maybe two) crosstable loads. See The Crosstable Load

Crosstable (Num, Value, 1)

Load

     Tourists,

     Num1,

     Num2,

     Num3,

     ...

     From table ;

HIC

[#4]

Hi

By using crosstable you can do this .

Please check this thread also for clear understand

Cross Table in QlikView | Learn QlikView

here is sample expression in the file.

n1 =sum(num1)

n2=sum(num2)

n3=sum(num3)

n4=sum(num4)

n5=sum(num5)

n6=sum(num6)

Total=sum(Totalnum)

check these expression in the Expressions tab by adding these data in the file

[#5]

Hi,

In straight table try this.

Expression 1: Sum(field 1)

Expression 2: Sum(field 2)

Expression 3: Sum(field 3)

Expression 4: Sum(field 4)

Total,

Expression 5: Sum(field 1) +Sum(field 2)+Sum(field 3)+Sum(field 4)