Discussion board where members can get started with Qlik Sense.
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.
What do you want to with this? Don't you mean a measure?
You can just use this formula, null() values are not calculated.
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.
This is something you can't do in the Data Manager. We can do it in the script if you want, okay?
Can you send the information in your load script?