topic different expression for different dimension and month in QlikView

different expression for different dimension and month

Anonymous — Thu, 03 Nov 2011 14:16:02 GMT

Hi,

I have different groups in a table as dimension. and in my expression i sum points. But for one group i want to sum points*0.7 if the point was registred any month exept june july or august. Otherwise it's jus sum(points).

Who do i write this in my expression to get i to work.

It's the month part i'm having problem with. This works fine:

if(Team='groupX', avg(aggr(count({$<points={'>0'}>} distinct person), date, group))*0.7,

avg(aggr(count({$<points={'>0'}>} distinct person), date, group))

)

//A.

different expression for different dimension and month

Thu, 03 Nov 2011 16:02:14 GMT

Have you tried something like this:

if(Team='groupX' AND Month <> 'June' AND Month <> 'July' AND Month <> 'August', avg(aggr(count({$<points={'>0'}>} distinct person), date, group))*0.7,

avg(aggr(count({$<points={'>0'}>} distinct person), date, group))

)

different expression for different dimension and month

Anonymous — Fri, 04 Nov 2011 11:31:45 GMT

no didn't work. still got the same result as the above one. despite different month selections

different expression for different dimension and month

rrsrini2907 — Fri, 04 Nov 2011 12:54:43 GMT

Hi,

Could you upload sample.

Regards,

Srini.

different expression for different dimension and month

Anonymous — Wed, 09 Nov 2011 13:54:46 GMT

I's woking when a chose one of these special months but if a pick a period between may and oktober the number are the same as the expression i described that worked.