topic Re: Table according to set analysis in QlikView

Table according to set analysis

Mon, 30 Jun 2014 14:19:39 GMT

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 !

Tue, 01 Jul 2014 12:52:03 GMT

Is someone knows if it is possible ?..

Thanks lot !

ashfaq_haseeb — Tue, 01 Jul 2014 13:00:29 GMT

Hi,

In back-end create a flag

If(Cost>Invoiced,1) as Invoice_Flag.

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

Regards

ASHFAQ

Fri, 04 Jul 2014 08:39:44 GMT

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 — Fri, 04 Jul 2014 08:43:31 GMT

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

Fri, 04 Jul 2014 13:43:07 GMT

It works !

Thanks