topic Re: Pick and Match in QlikView

Pick and Match

posywang — Wed, 22 Feb 2017 21:56:54 GMT

Hi,

I used Pick and Match function for the attached sample QVW but looks like the total line for Resp Code is blank. Is there a way to show correct amount? Thanks!

Re: Pick and Match

vishsaggi — Wed, 22 Feb 2017 22:42:02 GMT

Check this?

Just use this in your expense expression as

= Sum(Aggr(pick(match([Resource Type],'Contractor','GSO','EMP'),

sum({<Measures={'Actuals'},[Resource Type]={'Contractor'}>} Value),

sum({<Measures={'Actuals'},[Resource Type]={'GSO'}>} Value),

sum({<[Resource Type]={'EMP'}>} Census))

, [Resp Code], [Resource Type], Resource))

Re: Pick and Match

petter — Wed, 22 Feb 2017 22:52:21 GMT