Table according to set analysis

[#1]

Hello,

I am writing to you because I want to display data in a table, according to a set analysis.

=Count(If(Cost>Invoiced and Invoiced<>0 , Cost))

Before, what i did is that I had several dimensions, and my set analysis in an expression.

Then, I hide this column with set analysis.

But today, I need to add several calculated expressions, so my old way doesn't work anymore.

Is someone knows how can I display all my table according to the set analysis ?

Thanks !

[#2]

Is someone knows if it is possible ?..

Thanks lot !

[ashfaq_haseeb · Accepted solution]

Hi,

In back-end create a flag

If(Cost>Invoiced,1) as Invoice_Flag.

=Count({<Invoice_Flag={1},Invoiced-={0}>} Cost))

Regards

ASHFAQ

[#4]

Thanks Mohammed for your response.

Using only QVD for my script, like :

Sales:

Load *

FROM

\\Sales.qvd (qvd);

Do you know how can I insert the flag code :

If(Cost>Invoiced,1) as Invoice_Flag ?

Thanks

[ashfaq_haseeb]

Hi,

Assuming that bot fields are in the same table, try below

Sales:

Load *,If(Cost>Invoiced,1) as Invoice_Flag,

FROM

Sales.qvd (qvd);

Regards

ASHFAQ

[#6]

It works !

Thanks