Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
yadavsaket1
New Contributor II

Average multiple dimension in a new calculated field.

Hi,

Just need to average multiple dimension into one calculated field. also if there is a null value the average should not consider that in the calculation.

Thanks in advance.

5 Replies
Partner
Partner

Re: Average multiple dimension in a new calculated field.

Hi Yadavsaket,

What do you want to with this? Don't you mean a measure?

You can just use this formula, null() values are not calculated.

Avg([Your field])

 Jordy

Climber

Work smarter, not harder
yadavsaket1
New Contributor II

Re: Average multiple dimension in a new calculated field.

Hi,

Actually, there is more than 1 measure.

I have attached an excel file that makes it easy to understand.

check that it is not considering null values. I need to do this in Table(Data Manager).

Thanks in Advance.

Partner
Partner

Re: Average multiple dimension in a new calculated field.

HI Yadavsaket,

This is something you can't do in the Data Manager. We can do it in the script if you want, okay?

Jordy

Climber

Work smarter, not harder
yadavsaket1
New Contributor II

Re: Average multiple dimension in a new calculated field.

Sure. That will do.
Partner
Partner

Re: Average multiple dimension in a new calculated field.

Can you send the information in your load script?

Jordy

Climber

Work smarter, not harder