topic Re: Expression Issues in QlikView

Expression Issues

Tue, 01 Apr 2014 15:18:31 GMT

Hello,

I want to create an expression to count my data with a "where" clause like:

SELECT

COUNT(*)

FROM

TABLE1

WHERE

MONTH_START != MONTH_END;

But the following expression doesn't work: =COUNT( {< month_start != month_end >} my_id)

Can anyone help me?

giakoum — Tue, 01 Apr 2014 15:22:24 GMT

you will need either Only or the p function :

month_start={"$(=only(month_end))"}

month_start=p(month_end)

update (just noticed the !=):

month_start -={"$(=only(month_end))"}

month_start=e(month_end)

its_anandrjs — Tue, 01 Apr 2014 15:22:28 GMT

After loading data from SQL table make a QVD and then load data from QVD. When loading data from QVD check where condition like

load

CountField

From Location

Where MONTH_START <> MONTH_END;

Hope this helps

Tue, 01 Apr 2014 16:42:58 GMT

i've tried something like that, but it doesn't worked:

=COUNT({< MES-={"$(=only(MES_TER))"}>} CDCHAMADO)

=COUNT({< MES=e(MES_TER)>} CDCHAMADO)

am i doing something wrong?

Tue, 01 Apr 2014 16:43:37 GMT

thks, but i need it on the chart expression!

giakoum — Tue, 01 Apr 2014 16:47:49 GMT

Sample app?

Tue, 01 Apr 2014 17:02:44 GMT

A sample with a qvd file