Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yadavsaket1
Contributor II
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
JordyWegman
Partner
Partner

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
Contributor II
Contributor II
Author

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.

JordyWegman
Partner
Partner

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
Contributor II
Contributor II
Author

Sure. That will do.
JordyWegman
Partner
Partner

Can you send the information in your load script?

Jordy

Climber

Work smarter, not harder