topic Re: Total in Expression in QlikView

Total in Expression

QFanatic — Wed, 25 Nov 2020 16:16:04 GMT

hi guys

1. Please explain to me what the 'Total' in the following expression means...

2. I am specifying REQ_HOUR -= {'NULL'} in the Set Expression ,..would this hardcoded 'NULL' field also get excluded in the Total part? if not - how can I get that part explicitly excecuted in the Total...?

avg({$<PERIOD={$(vMaxMonth)},REQ_DATE=, TYPE_GRAPH = {'HOURLY'}, REQ_HOUR -= {'NULL'}>}total <WKDAY,REQ_HOUR> HOUR_VOLUME)

thanks

Re: Total in Expression

Saravanan_Desingh — Sat, 30 May 2020 19:11:04 GMT

TOTAL consider all selections you make. But ignores the row in the Table. The Aggregation will be done across the rows.

You can search in the community for more details.

Re: Total in Expression

Saravanan_Desingh — Sat, 30 May 2020 19:13:17 GMT

Just noticed.
Are you trying to remove the NULL values for REQ_HOUR, with the below code? Sorry its wrong.

REQ_HOUR -= {'NULL'}

Use below. It is equivalent to Not IsNull(REQ_HOUR).

REQ_HOUR = {"*"}

Re: Total in Expression

QFanatic — Sat, 30 May 2020 19:17:15 GMT

Hello,

I've built in a line in my code that says if(isnull(REQ_HOUR),'NULL',REQ_HOUR) as REQ_HOUR to try and 'catch' that null field.