
Creator
2019-04-08
09:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SUMIF function in Qliksense...
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!
4,700 Views
2 Replies

Partner - Contributor II
2019-04-08
03:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
4,678 Views


Specialist II
2019-04-08
04:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
4,673 Views
