topic Re: Set Analysis in QlikView

Set Analysis

kevbrown — Fri, 10 Mar 2017 11:24:23 GMT

Hi,

I'm looking to create some set analysis but it's not working

So what I have is Year, Month and Sales

I'm looking to sum sales where the year is always 2016 and the Month remains the same no matter what selection is made on it. I have -

=Sum({<[Year]={'2016'},{1}[Month]>}[Sales])

But it's stating I have an error

sunny_talwar — Fri, 10 Mar 2017 11:39:23 GMT

Try this (you don't need {1} next to Month)

=Sum({<[Year] = {'2016'}, [Month]>} [Sales])

kevbrown — Fri, 10 Mar 2017 11:40:50 GMT

Easy as that! thanks

dsharmaqv — Fri, 10 Mar 2017 11:41:31 GMT

try this

=Sum({<[Year] = {'2016'}, [Month]=>} [Sales])