topic Previous Year Problem in QlikView

Previous Year Problem

Wed, 03 Dec 2014 09:43:43 GMT

Hi,

i attached a file. Here you can see Chart 1 and Chart 2. In Chart 1 i have the correct result for Current Year and Previous Year (values for 2013 are the same for 2014 plus a zero). In chart 2 when i add the same set analysis present in Chart 1({$<Data = {$(=Only(Data)-1)}>}) i've a bad result for the Previous year...

Thx

Re: Previous Year Problem

Gysbert_Wassenaar — Wed, 03 Dec 2014 09:51:46 GMT

Add the set modifier to the inner aggregation function too.

=sum({$<Data = {$(=Only(Data)-1)}>} if(aggr(nodistinct count({$<Data = {$(=Only(Data)-1)}>}distinct if(isnull(CANC_Ar) AND isnull(CANC_Tr),$(=GetFieldSelections(_VariabileProdotto)))),NumScontrino)>=GetPossibleCount($(=GetFieldSelections(_VariabileProdotto))), TotRigaScontrino))

Re: Previous Year Problem

Wed, 03 Dec 2014 10:38:39 GMT

Great! Thx a lot. When we use aggr it's a rule? We have to add the set analysis to the inner aggregation function too?

Re: Previous Year Problem

Gysbert_Wassenaar — Wed, 03 Dec 2014 10:41:31 GMT

Usually yes. It depends on what you're trying to calculate.