# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Valued Contributor II

## Straight table sum up 4 row data , how to make it display 159,141 ?

Hi All

I got the below expression from Ram :-

'S\$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(

sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)

,'###,##0.00'),'###,##0')

But when it sum up the 4 row of data , it display S\$ 118,299 , which is wrong , How to make it display 159,141 ?

Paul

1 Solution

Accepted Solutions

## Re: Straight table sum up 4 row data , how to make it display 159,141 ?

Hi,

Try this.

'S\$ ' &Num(

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days3)

+ sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days6) +

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days9) +

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1))*above12)+

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * curren)

,'###,##0.00')

Regards,

Kaushik Solanki

4 Replies
Valued Contributor II

my QVW

## Re: Straight table sum up 4 row data , how to make it display 159,141 ?

Hi,

Try this.

'S\$ ' &Num(

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days3)

+ sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days6) +

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days9) +

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1))*above12)+

sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * curren)

,'###,##0.00')

Regards,

Kaushik Solanki

Valued Contributor II

## Re: Straight table sum up 4 row data , how to make it display 159,141 ?

Wow this is good, Thank a lot

Valued Contributor II

## Re: Straight table sum up 4 row data , how to make it display 159,141 ?

Now i am able to sort from hi to lo.