topic Need Help in QlikView

Need Help

suvechha_b — Thu, 26 Sep 2013 07:29:31 GMT

Can anyone suggest how to write the expression :

=sum({<{vMaxYear},{vMPeriod}>}[Actual Units])

Note :

vMaxYear,vMPeriod are variables.

suvechha_b — Thu, 26 Sep 2013 08:22:41 GMT

How to calculate sum([Actual Units]) depending on two variable given below

vMaxYear , vMPeriod .

How to write the expression ?

Thanks,

mphekin12 — Thu, 26 Sep 2013 12:44:28 GMT

Will this work:

sum({<Year={$(vMaxYear)}, Period={$(vMPeriod)}>} [Actual Units])

nizamsha — Thu, 26 Sep 2013 13:28:02 GMT

sum( {$<year={"$(=Max(year))"},month={"$(=Max(Month))"}>}actual unit)

v_iyyappan — Thu, 26 Sep 2013 13:45:23 GMT

Hi,

What you arrive in period variable? Whether its date means please check the date format are same in variable and Period column name.

Use like this

=Sum({<Year={$(vMaxYear)}, Period={$(vMPeriod)}>}[Actual Units])

Regards,