topic Re: Expression in QlikView

Expression

deepakqlikview_123 — Mon, 31 Mar 2014 12:20:29 GMT

Hello all,

Can you please tell me how below expression works,

=

count ({<Fab_Year = {$(=year(now()))},

Fab_Month = {

$(=month(now()))},

Fab_Day = {

$(=day(now()))},

Flag = {'2 Wheeler'}>}

CIS_NUMBER)
-

count ({<

Paint_Year = {

$(=year(now()))},

Paint_Month = {

$(=month(now()))},

Paint_Day = {

$(=day(now()))},

Flag = {'2 Wheeler'}>}

CIS_NUMBER)

thanks,

Deepak

Re: Expression

MK_QSL — Mon, 31 Mar 2014 13:04:38 GMT

Below Expression will give you COUNT of CIS_NUMBER

Where

Fab_Year = CURRENT Year,

Fab_Month = CURRENT Month

Fab_Day = Today

and

Flag = 2 Wheeler

count ({<Fab_Year = {$(=year(now()))},

Fab_Month = {

$(=month(now()))},

Fab_Day = {

$(=day(now()))},

Flag = {'2 Wheeler'}>}

CIS_NUMBER)

The same logic is applied to 2nd expression...

Now the final result is Result of Expression 1 - Result of Expression 2