topic Re: Functions P() and E() doubt in QlikView

Functions P() and E() doubt

Anonymous — Wed, 26 Mar 2014 18:03:58 GMT

Hello,

I am trying to create a KPI with the following formula:

=count( {$<ID_COMPANY=E({<LEVEL={">$(=vLevel)"}>})>} DISTINCT ID_COMPANY )

=count( {$<ID_COMPANY=E({<LEVEL={">$(=Column(6))"}>})>} DISTINCT ID_COMPANY )

But it is not working right. I am suspecting that I cannot use vars neither reference other expresions inside those functions.

* Does anybody can confirm this?

* Do you have any alternative?

Thanks in advance,

Javier

MK_QSL — Wed, 26 Mar 2014 18:28:24 GMT

You can use variable inside E and P....

Use like below..

=count( {$<ID_COMPANY=E({1<LEVEL={">$(=vLevel)"}>})>} DISTINCT ID_COMPANY )

Anonymous — Wed, 26 Mar 2014 19:05:19 GMT

Thanks for your prompt answer!!

Do you know if it is possible to use a the value in another expression (column)?

thkxs

MK_QSL — Wed, 26 Mar 2014 19:32:50 GMT

Can you upload your sample file or sample apps?

fernando_tonial — Wed, 26 Mar 2014 19:34:35 GMT

Replace Column(6) for your expression.

Best Regards.

Tonial.

Anonymous — Wed, 26 Mar 2014 19:54:59 GMT

Hello,

Column(6) does not seems to work. If I write the values it works.

Find example attached.

Regards

Javier

deepakqlikview_123 — Mon, 26 May 2014 04:28:11 GMT

Hi Javier ,

Can you please tell me how

=count( {$<CMT_NNUMSCH=E({$<NIVEL_HIJO={">Column(3)"}>})>} DISTINCT CMT_NNUMSCH )

Will works.I am not able to undershand.

Thanks,