Qlik Community

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.

paulyeo11
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
paulyeo11
Valued Contributor II

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

my qvw

arulsettu
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%')

arulsettu
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%')

paulyeo11
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

arulsettu
Honored Contributor III

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

set dimension SOURCE

Untitled.png

is this you are looking for?

paulyeo11
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