topic Re: How to convert table to chart ? in QlikView

How to convert table to chart ?

paulyeo11 — Tue, 02 Sep 2014 08:42:11 GMT

Hi All

In my previous post , the information i give is not so clear , so i try to post again :-

I need to plot the Table A 2 value 2,579,737 and 563,620 at chart A.

So my chart will display 2 bar , one bar = 2,579,737 another bar will display 563,620

Hope some one can advise me.

Paul

paulyeo11 — Tue, 02 Sep 2014 08:42:45 GMT

Enclosed my QV doc

MK_QSL — Tue, 02 Sep 2014 08:49:25 GMT

Create a bar chart...

DIMENSION

NO DIMENSION

EXPRESSIONS

NUM(SUM(IF(CURRENCY='EUR',TOTAL*1.64,

IF(CURRENCY='NT',TOTAL/24,

IF(CURRENCY='USD',TOTAL*1.25,

IF(CURRENCY='YEN',TOTAL*0.012,

IF(CURRENCY='SGD',TOTAL*1))

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

NUM(SUM(

IF(CURRENCY='EUR',DAY30*1.64,

IF(CURRENCY='NT',DAY30/24,

IF(CURRENCY='USD',DAY30*1.25,

IF(CURRENCY='YEN',DAY30*0.012,

IF(CURRENCY='SGD',DAY30*1))

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

paulyeo11 — Tue, 02 Sep 2014 09:41:12 GMT

Hi Manish

Your proposal work fine.

NUM(SUM(IF(US_Cust='EU',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1.64,

IF(US_Cust='NT',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))/24,

IF(US_Cust='USD',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1.25,

IF(US_Cust='YEN',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*0.012,

IF(US_Cust='SGD',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1))

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

But i have another table , with out provide me the total amount , i try above expression , it reutrn null value. any advise ?