Skip to main content

New to Qlik Sense

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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 - Master
Partner - Master

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 - Master
Partner - Master

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 - Master
Partner - Master

Can you send the information in your load script?

Jordy

Climber

Work smarter, not harder