Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

1 Reply
Partner
Partner

For the first calculation use

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

For the second use

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes