Stuck with aggregation - Qlik Community

Report Inappropriate Content · ‎2014-08-13

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

MK_QSL · ‎2014-08-13

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

Report Inappropriate Content · ‎2014-08-13

Could you please share your qvw?

muniyandi · ‎2014-08-13

can you post some sample file

Report Inappropriate Content · ‎2014-08-14

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.