Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
tata1488
Contributor
Contributor

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

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

16 Replies
susovan
Partner
Partner

You can also try this.

Capture.JPG

Warm Regards,
Susovan
susovan
Partner
Partner

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

Warm Regards,
Susovan
tata1488
Contributor
Contributor
Author

How did you get this?

vishsaggi
Champion III
Champion III

Hello Taher,

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

Appreciate it.

Thanks,
V.

qlikviewwizard
Master II
Master II

Hi tata1488

Did you able to do this?

tata1488
Contributor
Contributor
Author

Hi Arjun

This worked. Thanks

qlikviewwizard
Master II
Master II

Hi tata1488

Happy to hear.

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