Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
srinivas1921
Contributor III
Contributor III
‎2018-10-23 02:52 PM

Unable to get the exact results for sumifs formula (which is used in excel) using qlikview

Hi ,

Please help on write below excel formula in qlikview to get exact results.

img-1.JPG

img-2.JPG

164 Views
0 Likes
1 Reply
Vegar
MVP
MVP
‎2018-10-23 05:40 PM

For the first calculation use

Sum({<Level=-{1}>}[Sales MTD])

For the second use

Sum({<Level={1}>}[Sales MTD])

Vegar
Qlik Community MVP
135 Views
0 Likes