Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

Measure calculation ignore null or N/A field

Dear Team,

Please confirm how can i create my measure.for total column. i want to ignore null & N/A.

For example No 2,

8+2=10

Available score=2

10/2=5

Divide by 2 to reduce range (1-5) because initial score is (1-10)

5/2=2.5

ss.PNG

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Measure calculation ignore null or N/A field

use rangesum

Rangesum(Ascore,Bscore,Cscore)

5 Replies
MVP
MVP

Re: Measure calculation ignore null or N/A field

>> how can i create my measure

Except you have given no information about fields or tables, and ...


>>Available score=2

>>Divide by 2 to reduce range (1-5) because initial score is (1-10)

No idea what you mean by these statements

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
stuhico09
Contributor

Re: Measure calculation ignore null or N/A field

Dear Jonathan,

Period,No, Ascore,Bscore,CScore is my field.

Total is the measure i want to get.

Available score means it is not null or N/A. For row no 2, only Bscore not available. So, available score is 2 which is Ascore & Cscore.

i just divide by 2 because i want the range of total score to be from 1-5. initial score for Ascore,Bscore,Cscore is from 1-10.

sasiparupudi1
Honored Contributor III

Re: Measure calculation ignore null or N/A field

use rangesum

Rangesum(Ascore,Bscore,Cscore)

Re: Measure calculation ignore null or N/A field

Why don't you transform your score data so that the calculation can be made easier

The Crosstable Load

stuhico09
Contributor

Re: Measure calculation ignore null or N/A field

Thanks Sasidar.

Community Browser