Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to convert table to chart ?

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

3 Replies
paulyeo11
Master
Master
Author

Enclosed my QV doc

MK_QSL
MVP
MVP

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
Master
Master
Author

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 ?