Discussion board where members can get started with Qlik Sense.
Please confirm how can i create my measure.for total column. i want to ignore null & N/A.
For example No 2,
Divide by 2 to reduce range (1-5) because initial score is (1-10)
Go to Solution.
>> how can i create my measure
Except you have given no information about fields or tables, and ...
>>Divide by 2 to reduce range (1-5) because initial score is (1-10)
No idea what you mean by these statements
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.
Why don't you transform your score data so that the calculation can be made easier
The Crosstable Load