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

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

paulyeo11 — Fri, 29 Jul 2016 07:26:12 GMT

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

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

paulyeo11 — Fri, 29 Jul 2016 07:27:16 GMT

my qvw

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

arulsettu — Fri, 29 Jul 2016 07:39:25 GMT

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

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

arulsettu — Fri, 29 Jul 2016 07:42:00 GMT

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

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

paulyeo11 — Fri, 29 Jul 2016 08:04:18 GMT

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

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

arulsettu — Fri, 29 Jul 2016 08:08:47 GMT

set dimension SOURCE

is this you are looking for?

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

paulyeo11 — Fri, 29 Jul 2016 08:13:30 GMT

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

Sent from my iPhone