topic Re : Repeated Expressions in QlikView

Re : Repeated Expressions

Fri, 02 Apr 2010 11:12:57 GMT

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.

Fri, 02 Apr 2010 17:54:19 GMT

Have you tried setting the expression as a variable?

Then you could just use $ expansion in the chart.

Tue, 06 Apr 2010 13:52:50 GMT

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 — Tue, 06 Apr 2010 15:22:49 GMT

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