hello everyone I am new to qlik sense, I want to calculate a measure so please help me with it.
I have a field measure name and i would like the sum of value field i.e., sum(value) where the measure is revenue, how can i do this using a if condition.
Try this measure
hello thanku, but this would work in the front end i guess i would like to write a script with various measures in the data load editor.
load * Inline [c1,c2,c3A,5,6A,2,3B,8,9
LOAD if(c1='A',sum(c2)) as c2_sum,c1 Resident tab Group by c1;drop Table tab;
Maybe like this?
If(Measure='Revenue', Value) as Revenue