topic Re: help in set analysis in QlikView

help in set analysis

ali_hijazi — Mon, 23 Jun 2014 13:38:58 GMT

Dears

got a pivot table

that shows number of defects that are pre-release or post release

check attachment to understand what I'm going to ask

for v3.1.28 I have 53 prelease defects and 3 post release defects

each release v3.1.28 will have another column called release_phase that will be v3.1.28-PR if the defects dates are created after release dates and so on

for a given release x i want to sum all pre release plus those that are post release and for x-PR I want to sum only those that are post release

please help me with the third expression

check attachement and advise

for version v3.1.28 the third column should give 3 whereas when I select v3.1.29 with .28 it gives 7 (3+4) 3 for .28 and 4 for .29

Re: help in set analysis

maleksafa — Mon, 23 Jun 2014 13:59:10 GMT

here you go, you should use the aggr function and not the TOTAL function.

Re: help in set analysis

ali_hijazi — Mon, 23 Jun 2014 14:07:26 GMT

scroll down to the table and see that i gives null in the cells beneath

Re: help in set analysis

ali_hijazi — Mon, 23 Jun 2014 14:15:50 GMT

this is not correct Malek

Re: Re: help in set analysis

maleksafa — Mon, 23 Jun 2014 14:29:55 GMT

check now, for some dimensions the aggr is returning more than one value, that is why it is empty.