topic Stuck with aggregation in QlikView

Stuck with aggregation

Wed, 13 Aug 2014 14:27:50 GMT

Hi guys,

Hoping someone can help me here, is quite hard to explain but will give it a go.

I was looking for an expression to use in a line chart where the ITASTATS_Wave was a dimension. I wanted to show active responses for each wave defined by this formula:

sum(if(ITA_CHACTIVE=1 and ITASTATS_leaseCoHier=vLeaseco,1,0))

ITA_CHACTIVE gives 1 if parameters are met in the script for activity

What I was looking to do is to show the % of those active responses which are completely new for the ITASTATS_Wave.

Is it possible any help greatly appreciated

Re: Stuck with aggregation

MK_QSL — Wed, 13 Aug 2014 14:31:25 GMT

Not understood properly... Can you provide some sample data?

Re: Stuck with aggregation

Wed, 13 Aug 2014 17:48:24 GMT

Could you please share your qvw?

Re: Stuck with aggregation

muniyandi — Wed, 13 Aug 2014 18:41:13 GMT

can you post some sample file

Re: Stuck with aggregation

Thu, 14 Aug 2014 13:05:31 GMT

HI Guys

Have attached some sample data and another sheets with the results im trying to get to , I know there must be an easy way but so stuk

So wanted to check if an e-mail was responding to the wave for the first time broken down by wave, so wanted to show first time responders for that particular vLeaseco, by wave.

Hope that makes sense.