# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

#### Breathe easy -- you now have more time to plan your next steps with Qlik! QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Valued Contributor II

## 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

Hi All

I have a Table with 5 Column ,  which display the Out standing payment amount by days.

What i need is to compute the % in Pie chart to show the % contribution.

One of the approach is  i can add the column to display % contribution , it there a way i can have the % contribution on 2nd row , so that the table will not be too long.

Paul

6 Replies
Valued Contributor II

## Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

my qvw

Honored Contributor III

## Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

see this expression in pie chart

num((sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * curren))    /

(sum(

If( US_Cust='USD', 1.3,

If( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if( US_Cust='EU',1.5, 1))))* days3)

+ sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days6)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days9)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1))))*above12)

+sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * curren)),'#,##0%')

Honored Contributor III

## Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

for 30 days % use this

num((sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * days3))    /

(sum(

If( US_Cust='USD', 1.3,

If( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if( US_Cust='EU',1.5, 1))))* days3)

+ sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days6)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days9)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1))))*above12)

+sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * curren)),'#,##0%')

Valued Contributor II

## Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

Hi Arul

I try to create 2 expression in pie chart using the expression you posted. the pie chart not able to display any thing , when i convert pie chart to bar chart , i can see 2 bar. one long and one short. mean your expression for Curren and 30days work.

Any thing i need to set on pie chart ?

Paul

Honored Contributor III

## Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

set dimension SOURCE

is this you are looking for?

Valued Contributor II

## Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

I need 8 % and 13 % in one pie chart . Now you make it in 2 pie chart.

Sent from my iPhone

Community Browser