topic Re: Expression in QlikView

Expression

narender123 — Thu, 05 Feb 2015 11:48:05 GMT

Hi Team,

I want a expression monthly basis like:

=count({<Charge={2}>}distinct Employee) "this will show result in against of month dimention suppose feb"

count({<Charge={2},Month={Num(TPMonth) -1}>}distinct Employee) "then this will show result in against of (month-1) jan"

How i can achieve this??

Thanks,

Narender

Re: Expression

rubenmarin — Thu, 05 Feb 2015 12:19:33 GMT

Hi Narender, the calculted set analysis for month should be:

count({<Charge={2},Month={'$(=Num(TPMonth) -1)'}>}distinct Employee) "then this will show result in against of (month-1) jan"

Also notice that set analysis is calculated for the whole table, not row by row, so "$(=Num(TPMonth) -1)" will return only one value based on selections, not dimensions and it won't work when there are more than one possible TPMonth

Re: Expression

Thu, 05 Feb 2015 12:20:56 GMT

Hi,

I can't understand your question Can you explain it again about input and output