Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Previous' Month Value Issue

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: Previous' Month Value Issue

have you tried?

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

or

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

View solution in original post

5 Replies
MVP
MVP

Re: Previous' Month Value Issue

have you tried?

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

or

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

View solution in original post

Not applicable

Re: Previous' Month Value Issue

Try this:

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

MVP
MVP

Re: Re: Previous' Month Value Issue

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

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

Re: Re: Previous' Month Value Issue

You can also try with

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


Not applicable

Re: Previous' Month Value Issue

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