topic Re: new expression for calculated values from chart in QlikView

new expression for calculated values from chart

Tue, 08 Mar 2016 08:22:16 GMT

Hi,

anyone able to help. I need to have another line or symbol to represent the percentage of T40_Oppo vs Total 40ft

Both of these values belong to the 'field', <Types>.

so at Feb there should show 59.8% and Jan 37.6%

thank you so much

kaushiknsolanki — Tue, 08 Mar 2016 09:15:27 GMT

Hi,

You can use the Column(2)/Column(1) as Expression and change the number format to % from Number Tab.

Regards,

Kaushik Solanki

Tue, 08 Mar 2016 10:18:37 GMT

Hi,

the above does not work. I'm not sure if the expression should be changed or used as it is

kaushiknsolanki — Tue, 08 Mar 2016 10:44:33 GMT

Hi,

You will have to change the dimension and expressions.

Your chart dimesion should be. --- Month

Expressions should be.

1. Sum({<Types = {"T40_Opportunities"}>}Value)

2. Sum({<Types = {"Total 40ft"}>}Value)

3. Sum({<Types = {"T40_Opportunities"}>}Value) / Sum({<Types = {"Total 40ft"}>}Value)

Regards,

Kaushik Solanki

sunny_talwar — Tue, 08 Mar 2016 10:46:18 GMT

Would you be able to share your qvw file?

Tue, 08 Mar 2016 11:00:20 GMT

Hi Hi,

thank you so much. I used the expressions that you gave and got the presentation in the manner needed.

cheers!

kaushiknsolanki — Tue, 08 Mar 2016 11:29:20 GMT

Great..

Cheers..