Re : Repeated Expressions

[#1]

Hi Friends,

I'm designing report in QV.

In my report, i have developed expression.

Most expression have same conditions.

Is there any way to avoid this repeated expression?

This expression is used in single sheet and it should not affect the next sheet in the document.

Thanks in advance.

[#2]

Have you tried setting the expression as a variable?

Then you could just use $ expansion in the chart.

[#3]

Hi,

Yes, at present we create variable and use it as expression.

Is there anyway, like adding script and something.

Thanks for the reply.

[deepakk]

There are manu ways to do it..

Eg : We are checking if Customer is Active

Customer Sales Order Count

Sum(If(Customer_Status ='A',Sales)) Count(if(Column(1) > 0, OrderID)

You can use the expression in first column and in the second expression you can check if the COlumn(1) > 0...

Deepak