How to Add 2 expressions in Straight chart on same row?

[Anonymous]

Hi
i have a straight table with a column called "Cost".

i have added an expression which gives me Sum(cost) in USD. In the same Column i want to add another expression which will display the Sum(cost) in CAD.

How can i achieve this? If i add a new expression like 'sum(cost)*1.2' , it will display details in a new column which i dont need.

I just need the Aggregated Sums in same row for both USD and CAD.

Thanks

[susovan]

You can also try this.

[susovan]

If you want change USD manually, you can try this attached file.

[Anonymous]

How did you get this?

[vishsaggi]

Hello Taher,

If you got what you looking for can you please close your threads marking Correct/Helpful responses.

Appreciate it.

Thanks,
V.

[qlikviewwizard]

Hi tata1488

Did you able to do this?

[Anonymous]

Hi Arjun

This worked. Thanks

[qlikviewwizard]

Hi tata1488‌

Happy to hear.

Please mark Correct Answer and close the thread. Thank you.