SUMIF function in Qliksense...

[srini]

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!

[andradetobias]

Hey there.
Look at this document.

https://community.qlik.com/t5/Qlik-Education-Discussions/Set-Analysis-Manuals-and-tutorials/td-p/741...

You gotta use Set Analysis for conditional expressions.

[dwforest]

Set expressions are one way.
For simple conditions you can use combination of if and sum
Looks like you may be just doing a manual pivot. Might be better to learn Qlik than just replicating an Excel sheet; much more powerful for analyzing if built using data the way Qlik is designed to handle it.