Pie chart

[#1]

Hi to All,

Sorry for inconvinience,

I have pie chart with 3 expressions like "Promo sales in %","Promo sales in values" and "with out promo sales" in values in the form of cyclic groups.

if i want to show %s and values [By using first two two expressions when my courser moving to the piece of pie chart i have to show that values}  i shown that values and % in pie chart.

And i have to show that" Without Promo sales value "also in pie chart ie not a problem also by using cyclic group we can do that.

Here i have problem:::  if i will give cyclic group to three expressions " The values and % for first two expressions what i given for when my courser moving to the piece of pie chart is for showing values is not working "

Now how can i give (1) i have to show the "values and %" by using first 2 expressions {when my courser moving to the piece of pie chart i have to show the % as well as values}"

(2) and i have to show that expression" without promo sales value also".

please help me out this issue..

please help me..

Thanks in Advance.

Regards

Chandra

[rubenmarin]

Hi Chandra, you can use the Dual() funtion, ie:

Dual(Sum(Value) & ' (' & Num(Sum(Value)/Sum(TOTAL Value), '#,0%') & ')', Sum(Value))

The bold part is what user sees in when mouse over.

[#3]

Hi Ruben,

Thanks for your reply.

please can you give me a navigation.

Hope you understood.

where can i give that expression in Pie chart

Already i have three expressions.

Please help me out this issue Ruben.

Thanks in Advance

[rubenmarin]

Hi, it depends if for some reason you want to keep 3 expresions or change your first 2 dimensions with this one.

If you want to keep 3 expressions, you can set the dual expression if the first two, using the same first part of the dual funtion to create the string the user will see, and leave your actual expression(s) as the 2nd part of the dual function.

In example, if your first expression is "Sum(Value)", you can change it for:

Dual(Sum(Value) & ' (' & Num(Sum(Value)/Sum(TOTAL Value), '#,0%') & ')', Sum(Value))

The bold part is the string user sees in when mouse is over. The Italic part is your actual expression(s), wich QV uses to calculate the graph.