topic Re: Set Analysis AND?? in QlikView

Set Analysis AND??

feg — Wed, 25 Nov 2020 16:16:04 GMT

HI all,

I would like to create a set expression that return:

sales for for all the customers that were in region A in the month of October and in the region B in the month of November.

Amy idea?

sunny_talwar — Thu, 24 Mar 2016 10:51:19 GMT

May be this:

Sum({<customers = p({<Region = {'A'}, Month = {'Oct'}>}) * p({<Region = {'B'}, Month = {'Nov'}>})>} sales)

Chanty4u — Thu, 24 Mar 2016 10:54:02 GMT

chk dis

Sum({<fileld = p({<region = {'values'},[ month field] = {'monthname'}>}) sales)

martinpohl — Thu, 24 Mar 2016 10:55:39 GMT

use this expression:

sum({<Region={A},Month={October}>+<Region={B},Month={November}>}Sales)

Regards