topic Re: Re: Previous' Month Value Issue in QlikView

Previous' Month Value Issue

Tue, 15 Apr 2014 16:36:45 GMT

Hello,

I'm trying to get a result from the previous month. No sucess so far. Here's the expression:

count({$<ANO_MES={$(v_mes_anterior)}>}ID)

ANO_MES is the month's name: Jan/14,Feb/14...
v_mes_anterior is the variable that reveals the previouos month: =(Date(addmonths(Max(ANO_MES), -1),'MMM/YY'))
ID: dimension that I'm using

When I use the first expression above all can I get it's a null value. Can someone help me to solve this?

Thanks!

MK_QSL — Tue, 15 Apr 2014 16:39:40 GMT

have you tried?

count({$<ANO_MES={"$(=v_mes_anterior)"}>}ID)

count({$<ANO_MES={'$(=v_mes_anterior)'}>}ID)

Tue, 15 Apr 2014 16:59:03 GMT

Try this:

=Count({<ANO_MES={"$(=v_mes_anterior )"}>} ID)

maxgro — Tue, 15 Apr 2014 16:59:23 GMT

you can try with (add ' ' to your expression)

=count({$<ANO_MES={'$(v_mes_anterior)'}>}ID)

its_anandrjs — Tue, 15 Apr 2014 17:09:30 GMT

You can also try with

count({ <ANO_MES={' $(=(Date(addmonths(Max(ANO_MES), -1),'MMM/YY'))) '}>}ID)

Tue, 15 Apr 2014 17:33:53 GMT

Yes! It worked. Thanks a lot, Manish, Massimo and Padmaja!