topic problem with set analyzer in QlikView

problem with set analyzer

oarjef — Mon, 11 Jan 2010 10:49:58 GMT

Hi all,

I found the next problem: i have a column within graph object (simple table) filled with the next expression:

=If((sum( {$<any = {$(#PreviousYear1)}>} amount) = 0) and (sum( {$<any = {$(#PreviousYear2)}>} amount) = 0), sum( {$< any = {$(#CurrentYear)}>} amount), 0)

The expression is ok (it shows the new customers amount, it doesn't matter). But now I would like to get the "new customers number", the total number of new customers (i.e..: NEW=nnnn) on the label of the expression, but I don´t know how could I done it.

Help me, please!

Thanks for all!

problem with set analyzer

Mon, 11 Jan 2010 11:46:38 GMT

You can create an expression in the label.


='NEW='&expression

Often, this expression is the same as the one used for the column.

problem with set analyzer

oarjef — Mon, 11 Jan 2010 12:11:07 GMT

Thanks Mark,

I know. But my problem is the expression

problem with set analyzer

Mon, 11 Jan 2010 15:11:38 GMT

If you set a new customer flag at load time the label expression becomes trivial and you can use the flag to do all sorts of new customer calculations.

Check for (count of orders < date) = 0 and (count of orders > date) > 1 then set flag = 1