Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I am converting my excel report to qlik sense where I am find difficulties to convert SUMIF function used in excel.
=SUMIF($AQ$3:$BB$3,$CO$1,$AQ1553:$BB1553)
$AQ$3:$BB$3=>
AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB |
3 | 3 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
$CO$1=>3 which is a month
$AQ1553:$BB1553=>
AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB |
M01 Units | M02 Units | M03 Units | M04 Units | M05 Units | M06 Units | M07 Units | M08 Units | M09 Units | M10 Units | M11 Units | M12 Units |
0 | 0 | 0.52903 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
can some one please help me to get this one in qlik sense?
Thanks!