Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

srinivas1921
New 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

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

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