topic Re: How to Add 2 expressions in Straight chart on same row? in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sergio0592 — Sun, 27 May 2018 20:03:34 GMT

Hi, and if you try with :

='USD : '&sum(cost)&', CAD : '&(sum(cost)*1.2)

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

qlikviewwizard — Mon, 28 May 2018 01:46:13 GMT

Hi,

Try like this.

='USD : '&num(sum(Cost),'#,##0')&' - CAD : '&(num(sum(Cost)*1.2,'#,##0'))

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

Anonymous — Mon, 28 May 2018 21:16:59 GMT

Hi Arjun

Thank. This worked. But, i was looking for an output like below(From Excel):

Rate	Cost
$0.5330	$3.96
$0.5330	$1.34
$0.5330	$0.63
$0.5330	$15.31
$0.5330	$18.66
$0.5330	$7.46
$0.5330	$0.13
	Total Cost
CAD	$47.49
USD X 1.2932	$61.41

So, under the cost field, i just want the USD calculation per row, but at the end, i want 2 rows to be displayed. One giving the value in CAD and one in USD.

Also, is there any way we can enter the USD rate dynamically while generating the Qlikview report?
When i pull report today, the rate maybe 1.293 and enxt month it could be 1.273, so can we enter this value manually?

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

qlikviewwizard — Tue, 29 May 2018 14:50:38 GMT

Hi Taher Talib,

Please check now.

='USD : '&num(sum(Cost),'#,##0.##')&' - CAD : '&(num(sum(Cost)1.2932,'#,##0.##'))*

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

qlikviewwizard — Tue, 29 May 2018 14:52:21 GMT

Please check this app.

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

Anonymous — Tue, 29 May 2018 15:22:58 GMT

Thanks for your help Arjun.

Also, could you please let me know how to edit a label for Straight table?

I am using the below in Dimensions tab in Straight table to get the number to 4 decimal points and this expression is displayed as a label in the straight table.

=Num(MINUTES,'##.0000')

How to change the lable name to "XX Minutes" instead of above expression?

Thanks

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

olivierrobin — Tue, 29 May 2018 15:45:13 GMT

hello

in your expression, use

if(dimensionality()=0, Code here what you want to see on total row,

sum(cost)

)

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

shansundar — Tue, 29 May 2018 15:57:00 GMT

Add two dummy values to your dimension like USD Cost & CAD Cost and then handle it with 'if else' or 'Pick Match' in your expression.

Please share an sample app if you want me to try.

Thanks,

Shan S

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

qlikviewwizard — Wed, 30 May 2018 06:00:13 GMT

Hi,

Please check this.

=num(sum(Cost),'#,##0.##') & ' Minutes'

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

susovan — Wed, 30 May 2018 06:40:27 GMT

You can also try this.

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

susovan — Wed, 30 May 2018 06:44:21 GMT

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

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

Anonymous — Wed, 30 May 2018 16:38:38 GMT

How did you get this?

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

vishsaggi — Wed, 30 May 2018 19:53:40 GMT

Hello Taher,

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

Appreciate it.

Thanks,
V.

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

qlikviewwizard — Thu, 31 May 2018 00:17:29 GMT

Hi tata1488

Did you able to do this?

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

Anonymous — Fri, 01 Jun 2018 19:55:49 GMT

Hi Arjun

This worked. Thanks

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

qlikviewwizard — Sat, 02 Jun 2018 11:36:26 GMT

Hi tata1488‌

Happy to hear.

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

topic Re: How to Add 2 expressions in Straight chart on same row? in QlikView

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

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

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

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

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

='USD : '&num(sum(Cost),'#,##0.##')&' - CAD : '&(num(sum(Cost)*1.2932,'#,##0.##'))

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

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

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

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

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

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

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

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

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

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

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

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

='USD : '&num(sum(Cost),'#,##0.##')&' - CAD : '&(num(sum(Cost)1.2932,'#,##0.##'))*